How to: View Job Activity (Transact-SQL)
This topic describes how to use stored procedures to view the runtime state of SQL Server Agent jobs.
To view job activity
Execute sp_help_jobactivity to view all SQL Server Agent jobs for the SQL Server instance.
To view activity for a specific job, specify the job name. To view activity for a specific SQL Server Agent session, specify the session ID.