The SQL Agent Jobs view allows you to view all your SQL Agent Jobs for the selected SQL Server instance. You can view the Job History of SQL Agent Jobs in the Job History list and Job Steps by clicking the + button next to the Job Name.
SQL Server 2005 users may notice that SQL Diagnostic Manager does not display the Job History for the listed SQL Agent jobs. These issues is the result of a SQL Server 2005 security setting. You can override this security setting by using the following statement on the target server:
sp_configure 'agent XPs',1
reconfigure with overrid
Access the SQL Agent Jobs view
To open the SQL Agent Jobs view of the SQL Diagnostic Manager Services tab. select the appropriate SQL Server instance, click Services, and SQL Agent Jobs.
Last Run Outcome colors
The Last Run Outcome column of the SQL Agent Jobs page is color coded to quickly alert you of issues needing your attention. The colors used in this column depend on the use of the SQL Agent Job Completion metric in the Alert Configuration dialog.
If this metric is enabled, the Last Run Outcome column is colored based on the correlation of the outcome of the job or job step and the state that outcome corresponds to in the SQL Agent Job Completion metric. If this metric is not enabled, then SQL Diagnostic Manager displays results in red if the outcome is Failed or Canceled, and green if the outcome is Succeeded. All other outcome states remain the default color.
To customize the Last Run Outcome settings for your SQL Agent jobs:
- Right-click a SQL Server instance in the Servers tree.
- Select Configure Alerts.
- Select the SQL Server Agent Job Completion metric.
- Click the Edit button.
- Make the necessary changes to customize your alert states.
- Click OK.
View message information about a specific job
Use the Job History list to see more information about a specific job. You can review the full message by right-clicking the appropriate job name, and then selecting View Message. A copy feature allows you to cut and paste the message detail into another format for additional use.