Post reply

Jobs Deadlocked

  • November 20, 2014 at 1:42 pm

    #313275

    How do I take this and figure out what the job was? (from the deadlocked report in SQL Sentry)

    SQLAgent - TSQL JobStep (Job 0x5FABFDB18CA34A4C83D6CFB5CE6751AD : Step 3)

  • November 21, 2014 at 2:06 am

    #1760039

    It is the job_id:

    select * from msdb..sysjobs where job_id = 0x5FABFDB18CA34A4C83D6CFB5CE6751AD

    -- Gianluca Sartori

  • November 21, 2014 at 6:59 am

    #1760109

    Ok thanks.. got misled by it stating job step.

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

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