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

  1. 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.

See Also

Concepts

Monitoring Job Activity

Other Resources

sp_help_jobactivity (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance