Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Job Activity Monitor

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Use this page to view the current activity of SQL Server Agent jobs. Click Filter to limit the jobs displayed. The Agent Job Activity grid is read-only. Click on the column headers to sort the grid. To modify a job, double-click the job to open the Job Properties dialog box. Right-click a job in the grid to start it running all job steps, start at a particular job step, disable or enable the job, refresh the job, delete the job, view the history of the job, or view the properties of the job. Click Refresh to update the grid with current information.

Name

Name of the job.

Enabled

Whether the job is enabled (yes) or not enabled (no).

Status 1

Current status of the job.

Last Run Outcome

Job status when last run.

Last Run

Date and time job was last run using the local date and time of the server.

Next Run 1

Date and time the job is next scheduled to run using the local date and time of the server.

Category

The job category assigned to the job.

Runnable

Yes if the job can be run; No if the job cannot be run. A job is not runnable if it has no steps or if it has no target server.

Scheduled

Yes if the job is assigned to a job schedule; No if the job has no schedule.

1Only members of the SQL Server sysadmin fixed server role and the server administrators group can see values in this column. Members of the SQLAgentOperatorRole role cannot see values in this column.

To open the Job Activity Monitor

  • In Object Explorer, expand your server, expand SQL Server Agent, right-click Job Activity Monitor, and then click View Job Activity.

Community Additions

ADD
Show:
© 2015 Microsoft