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.

  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.

Community Additions

ADD
Show:
© 2014 Microsoft