Looking through Waits in my MDW I often see things like …

Program Name: SQLAgent- TSQL JobStep (Job 0xE1C7AC4DC0E60E43934

… and have found I can usually get the job name from just the first few digits. EG:-

SELECT [name]
FROM msdb.dbo.sysjobs
Where CONVERT(char(32),CAST(job_id AS binary(16)),2) like 'E1%'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s