x

[Closed] 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?
more ▼

asked Aug 01 '10 at 09:45 PM in Default

Cyborg gravatar image

Cyborg
10.6k 36 39 45

(comments are locked)
10|1200 characters needed characters left

The question has been closed Aug 04 '10 at 12:03 AM by Cyborg for the following reason:


2 answers: sort voted first

hi is this the erroe you get "Invalid buffer recieved from client"

"Error: 17805, Severity:20 State:3"
more ▼

answered Aug 01 '10 at 10:32 PM

ramesh 1 gravatar image

ramesh 1
2.1k 59 67 69

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"
Aug 01 '10 at 10:44 PM Cyborg
(comments are locked)
10|1200 characters needed characters left

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!

more ▼

answered Aug 02 '10 at 05:46 AM

Cyborg gravatar image

Cyborg
10.6k 36 39 45

self-inflicted punishment? Nice one!
Aug 04 '10 at 02:02 AM ThomasRushton ♦

@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...
Aug 04 '10 at 02:07 AM Cyborg
(comments are locked)
10|1200 characters needed characters left

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x86
x85
x73

asked: Aug 01 '10 at 09:45 PM

Seen: 2737 times

Last Updated: Aug 02 '10 at 12:20 AM