Post reply

Job Failure Mystery

  • October 16, 2013 at 4:05 am

    #278970

    I have a nightly 10 step job, and step 4 has started failing a few days a week randomly. It rebuilds a table, only touching 1 database local on the server. The unhelpful message is:

    Msg 0, Sev 0, State 1: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]

    When I rerun beginning at step 4 it always completes normally. This has been running for months with no problems. Where do I look for the cause ?

  • October 16, 2013 at 4:42 am

    #1658838

    A KILL command will generate that error. Check the error logs to confirm.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • October 16, 2013 at 5:01 am

    #1658841

    Plz Check any script in the job is killing the connections.

  • October 16, 2013 at 8:24 am

    #1658934

    Looking through a server side trace that was running, and logs, I can not see a cause of failure.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply