Olá pessoal, humildemente peço que alguem me ajude.
Eu utilizo o sitema de auto reset em meu servidor só que o job não está quando eu dou start ele da erro
IMAGEM
[Only registered and activated users can see links. Click Here To Register...]
STEP
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=300+300*resets,
resets=resets+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('18'),
Energy=('18'),
MapNumber=('0'),
MapPosX=('125'),
MapPosY=('125')
FROM Character
JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
and resets<999
AND MEMB_INFO.vip = 0
HISTORICO DE ERRO NO SQL
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
07/10/2016 10:34:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:34:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by User sa. The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:24:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:24:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
Postado originalmente por sampaforce [Only registered and activated users can see links. Click Here To Register...]Olá pessoal, humildemente peço que alguem me ajude.qual game server ta usando man e qual versão
Eu utilizo o sitema de auto reset em meu servidor só que o job não está quando eu dou start ele da erro
IMAGEM
[Only registered and activated users can see links. Click Here To Register...]
STEP
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=300+300*resets,
resets=resets+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('18'),
Energy=('18'),
MapNumber=('0'),
MapPosX=('125'),
MapPosY=('125')
FROM Character
JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
and resets<999
AND MEMB_INFO.vip = 0
HISTORICO DE ERRO NO SQL
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
07/10/2016 10:34:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:34:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:33:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:33:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:32:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:32:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:31:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:31:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:30:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:30:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:29:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:29:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:28:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:28:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by User sa. The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:27:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:27:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:26:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:26:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:20,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:20,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:25:00,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:25:00,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
07/10/2016 10:24:40,AutoReset,Error,,WIN-C74UNR176GQ,AutoReset,,,The job failed. The Job was invoked by Schedule 26 (AutoReset). The last step to run was step 1 (AutoReset).,00:00:00,0,0,,,,0
07/10/2016 10:24:40,AutoReset,Error,1,WIN-C74UNR176GQ,AutoReset,AutoReset,,Executed as user: NT SERVICE\SQLSERVERAGENT. Subquery returned more than 1 value. This is not permitted when the subquery follows =<c/> !=<c/> <<c/> <= <c/> ><c/> >= or when the subquery is used as an expression. [SQLSTATE 21000] (Error 512) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.,00:00:00,16,3621,,,,0
Todos horários são GMT -2. Hora atual: 11:27 PM.Powered by vBulletin™ Version 4.2.5
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.vBulletin Security provided by vBSecurity (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
