Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Identifying SQL Agent Job Name based on the job id.

    I have just been working on this annoying issues and found several solutions:

    -- convert job_id from sysjobs table to get the job

    select * from msdb.dbo.sysjobs where CONVERT(binary(16), job_id)=0x5C0B2682FA10FE46983970CC3F0E2F68

    -- Below...

Viewing post 1 (of 1 total)