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:
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).
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.
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.
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:
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. |
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:
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. |
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:
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:
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:
IDERA Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|