question

Cyborg avatar image
Cyborg asked

Job failed to complete

Hi all, I created a job on my production server to rebuild indexes, Later when i examined the job history the job ran for 30 min and failed to complete, the message returned was > "NT AUTHORITY\SYSTEM. Unspecified > error occurred on SQL Server. > Connection may have been terminated by > the server. [SQLSTATE HY000] (Error > 0). The step failed" What might caused the job to failed?
sql-agentjoberror-message
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

ramesh 1 avatar image
ramesh 1 answered
hi is this the erroe you get "Invalid buffer recieved from client" "Error: 17805, Severity:20 State:3"
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image Cyborg commented ·
no @Ramesh, the message is "NT AUTHORITYSYSTEM. Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0). The step failed"
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
Hi all! I found the problem, actually there was a job that was scheduled to run every 30 min to kill all the session that are 30 min old, so my job become a victim for that. Thanks!
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
self-inflicted punishment? Nice one!
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
@ThomasRuston it was funny!. That dangerous job was created by an ex-developer, i am unaware about that. Actually i was appointed as a new DBA recently...
0 Likes 0 ·