Skip to content

Latest commit

 

History

History
67 lines (46 loc) · 3.5 KB

view-job-activity.md

File metadata and controls

67 lines (46 loc) · 3.5 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
View Job Activity
View Job Activity
markingmyname
maghan
01/19/2017
sql
ssms
how-to
viewing job activity
jobs [SQL Server Agent], viewing
SQL Server Agent jobs, viewing
displaying job activity
= azuresqldb-mi-current || >= sql-server-2016

View Job Activity

[!INCLUDE SQL Server SQL MI]

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

This topic describes how to view the runtime state of [!INCLUDEssNoVersion] Agent jobs in [!INCLUDEssnoversion] by using SQL Server Management Studio or [!INCLUDEtsql].

When the [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Agent to view the current state of jobs. If the [!INCLUDEssNoVersion] Agent service unexpectedly terminates, you can refer to the sysjobactivity table to see which jobs were being executed when the service terminated.

Before You Begin

Security

For detailed information, see Implement SQL Server Agent Security.

Using SQL Server Management Studio

To view job activity

  1. In Object Explorer, connect to an instance of the [!INCLUDEssDEnoversion], 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.

Using Transact-SQL

To view job activity

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- lists activity for all jobs that the current user has permission to view.  
USE msdb ;  
GO  

EXEC dbo.sp_help_jobactivity ;  
GO

For more information, see sp_help_jobactivity (Transact-SQL).