-- List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like 'SQLAgent%' spid program_name blocked ------ --------------------------------------------------------------------------------- ------- 148 SQLAgent - TSQL JobStep (Job 0x6CDB1221B7584941B63E44C95E805E43 : Step 1) 0 -- Using the Job from program_name in Step 1, find information on the job select job_id, name, description from msdb..sysjobs … Continue reading How to identify the job running through SQLServer Agent using SQL? →