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.