Page History
...
Tip |
---|
SQL Server 2005 users may notice that SQL Diagnostic Manager does not display the Job History for the listed SQL Agent jobs. This 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 |
...
- 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, and then 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.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...