SQL Enterprise Job Manager lets you view the specific details of any SQL Server instance you select. For this purpose, click the name of the Instance from any section of the console, and you will be directed to the Instance Details tab.
In this view you can see the following information:
Instance Alerts
In this section, you can see all the alerts that belong to the specific instance. These alerts help you get an overview of the most critical issues regarding the status of your specific instance.
The alerts in this section are ordered by level of severity and grouped by alert rule. SQL Enterprise Job Manager displays four levels of alerts severity, also identified with colors: Critical (red), Warning (yellow), Informational (gray), and OK (green).
How can you order alert rules?
By default, alert rules are ordered by severity from the most critical to those alert rules with OK severity. If you want to change this order, go to the top menu options of the alert rules section for this instance and click Sort by Severity.
How can you hide all displayed alert rules?
If you do not want to see any of the SQL Enterprise Job Manager alerts for this instance, go to the top menu options of this section and click Hide Alerts.
To view all alerts again, click Show Alerts.
What actions can you perform on each Alert Rule?
You can perform actions on each alert rule as well as on each job alert that belongs to an alert rule.
Alert rules display the number of job alerts associated with them. On each alert rule you can:
- Show Details - to see the complete list of job alerts that belong to a specific alert rule. You can use Hide Details to display only the summarized form of the alert rule.
- Dismiss - to ignore the complete alert rule with their associated job alerts.
- Collect Data - to get a recent status of the alert rule.
When you Dismiss an alert rule, it will not be displayed on the rules section temporarily. SQL Enterprise Job Manager will raise the alert rule when the condition happens again. For example: When a job status changes.
When you dismiss an alert, a dialog window opens to confirm this action, you can enable the option Do not show this warning again so that SQL Enterprise Job Manager does not prompt this warning message every time you dismiss an alert.
What actions can you perform individually on each job alert?
When you choose to Show Details of a specific alert rule, you can see all jobs alerts associated with a specific alert rule. On each alert you can:
- Depending on the alert rule, you can execute job actions like: Start job (job failures alerts) or Start SQL Server Agent (Agent not running alerts).
- Dismiss - to ignore the alert for a specific job alert.
- Collect Data - to get the most recent alert status for a specific job.
When you Dismiss a job alert, it will not be displayed on the alert section temporarily. SQL Enterprise Job Manager will raise the alert when the alert rule condition of the respective job is triggered again.
Read-only users cannot perform actions such as starting SQL Server Agents or starting jobs.
For more information about what alert rules are available by default in SQL Enterprise Job Manager and how you can add your own customized alert rules, go to Managing Alerts.
Job Schedule
In this section, you can view the scheduled jobs of your specific instance. You can view what jobs already ran or are scheduled to run in the present day.
To view jobs on other dates, click View Full Schedule and SQL Enterprise Job Manager directs you to the Schedule tab where you can select the time range and apply more detailed filters.
How do you identify job status with colors?
You can identify jobs' status with the following colors:
- Red - Failed
- Blue - Currently running
- Light Blue - Scheduled to run
- Green - Succeeded
- Gray - Retry
- Yellow - Canceled
Job History
In the lower section of your Instance view, you can see the job history information of your instance. In this section you can view the following information:
- Status - displays the status of each job event (every time the job runs)
- Date/Time - displays the date and time of each job event, including the time zone.
- Duration - shows the duration in hh:mm:ss of each job event (total duration of all steps executed for that job event).
- Instance - displays the name of your respective SQL Server instance.
- Job Name - displays the name of the job
- Message - displays additional information about the job event: status, schedule used, the last step ran, etc.
This section allows you to drill into any job event and see more specific information about its steps. Click the button to expand and view the following information of each step:
- Status - displays the status of each step.
- Date/Time - shows the date, time, and timezone when the step finished.
- Step ID - displays the identification number (ID) of each step.
- Step Name - displays the name of the step.
- Message - shows additional information about the step.