January 11, 2013 at 6:48 am
I'm trying to track down the job_id for a job that sent an auto-email alert to us this morning. The information I have is:
The host SERVERNAME has logged in with the functional login 'sa' using SQLAgent - TSQL JobStep (Job 0x3FF647C915B5604EAAAEBB0385D81250 : Step 1).
The number doesn't equate to a UNIQUEIDENTIFIER or any Job_ID in sysjobs. Does anyone have advice on how I can make the connection?
June 18, 2013 at 7:34 am
Apparently the answer is not to use quotes around the hex and to treat this as the job_id.
SELECT * FROM msdb.dbo.sysjobs
WHERE Job_ID = 0x3FF647C915B5604EAAAEBB0385D81250;
SQL Server does the auto translate without needing any additional functions or definitions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply