Find name of job based on GUID

[wilbiew]

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!

[rmiao]

Checked msdb..sysmaintplans?

[wilbiew]

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?

[rmiao]

Where did you get the message?

[jezemine]

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