Previous Topic: Retrieve the Details of a MSSQL Server JobNext Topic: Retrieve the Step Log for a MSSQL Server Job

Related Documentation › Retrieve the Status of a MSSQL Server Job

Retrieve the Status of a MSSQL Server Job

You can retrieve the status of a MSSQL Server job. The status details include the name of the server the job belongs to, last time the job ran, outcome of the job last time it ran, current execution status of the job, job step that is currently running, current retry attempt if the job is running and the step has been retried, and so on.

Follow these steps:

  1. Right-click the MSSQL Server job in the Monitor perspective.

    A list of job commands appears.

  2. Select Get Job Status.

    The Get Job Status dialog displays the status details of the job.

    Note: The agent administrator can configure the properties files on the agent to change the fields that are displayed in the table. For more information about configuring the properties files and the available fields that can be displayed, see the CA Workload Automation Agent for Microsoft SQL Server Implementation Guide.