Results 1 to 5 of 5

Thread: Find name of job based on GUID

  1. #1
    Join Date
    Nov 2004
    Posts
    66

    Find name of job based on GUID

    I have a message "SQLAgent - TSQL JobStep (Job 0xEDF5B927B56D3445893EF1360ADEE0FB : Step 1) " but I don't know how to find the job name.

    Is there a way to find the name based on the ID: 0xEDF5B927B56D3445893EF1360ADEE0FB?

    It doesn't seem to match any of the IDs in the sysjobs table in the MSDB database.

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Checked msdb..sysmaintplans?

  3. #3
    Join Date
    Nov 2004
    Posts
    66
    Thanks for the response.

    I took a look at those tables, and some others, but not much luck. Perhaps someone has come across this, and has a query to convert the job ID?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Where did you get the message?

  5. #5
    Join Date
    Aug 2006
    Posts
    57
    that value is not a guid, at least not represented the usual way. It's represented as an array of bytes as it is written.

    Try this and see if you get a match:

    select cast(job_id as varbinary(100)), job_id, name from msdb.dbo.sysjobs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •