Post reply

sysjobhistory with a run_status of 4

  • March 1, 2012 at 8:09 am

    #265374

    Hi All

    Just looking through sysjobhistory as our 3rd party is reporting job failures even though the jobs havnt failed and I noticed that there where jobs in the history table with a status of 4.

    I was sure the only valid values where 0, 1, 2 and 3 and confirmed this with the msdn page on sysjobhistory.

    Just wondering what status 4 is?

    Thanks

  • March 1, 2012 at 8:41 am

    #1453686

    From BOL for SQL 2000...

    0 = Failed

    1 = Succeeded

    2 = Retry

    3 = Canceled

    4 = In progress

  • March 1, 2012 at 8:56 am

    #1453707

    Damn them for updating BOL,

    Thanks for that, just so you know its not me going crazy

  • March 1, 2012 at 10:03 am

    #1453755

    I know you're not going crazy 🙂

    I was searching for the same information a few months ago, which was why I remembered it was in the SQL 2000 documentation.

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

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