Post reply

Tracking Job Info from AutoEmail

  • January 11, 2013 at 6:48 am

    #269183

    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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 18, 2013 at 7:34 am

    #1625029

    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.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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