How to: View Job Activity (SQL Server Management Studio)

When the Microsoft SQL Server Agent service starts, a new session is created and the sysjobactivity table in the msdb database is populated with all the existing defined jobs. This table records current job activity and status. You can use the Job Activity Monitor in SQL Server Agent to view the current state of jobs. If the SQL Server Agent service unexpectedly terminates, you can refer to the sysjobactivity table to see which jobs were being executed when the service terminated.

To view job activity

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent.

  3. Right-click Job Activity Monitor and click View Job Activity.

  4. In the Job Activity Monitor, you can view details about each job that is defined for this server.

  5. Right-click a job to start it, stop it, enable or disable it, refresh its status as displayed in the Job Activity Monitor, delete it, or view its history or properties.

    To start, stop, enable or disable, or refresh multiple jobs, select multiple rows in the Job Activity Monitor, and right-click your selection.

  6. To update the Job Activity Monitor, click Refresh. To view fewer rows, click Filter and enter filter parameters.

See Also

Concepts

Monitoring Job Activity
Failover Cluster Troubleshooting

Other Resources

sysjobactivity (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance