Export (0) Print
Expand All

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.

Community Additions

© 2015 Microsoft