SQL Enterprise Job Manager allows you to see the specific details for a selected Job. This view includes all your job information across all instances associated with it.
To access this view, click the name of the Job on the Jobs tab and a new page opens displaying your Job Details with the following sections:
Job Alerts
In this section, you can view all alerts related to your job across all instances associated with it. The alerts in this section are ordered by level of severity and grouped by alert rule.
In the Alerts section, you can perform the following actions:
- Sort by Severity - Use this option to order your alerts by severity. SQL Enterprise Job Manager displays four levels of alert severity, also identified with colors: Critical (red), Warning (yellow), Informational (gray), and OK (green).
- Hide Alerts - Select this option if you do not want to see any of the displayed alerts. Use Show Alerts to view all alerts again.
For each alert rule you can view the following options:
- Show Details - By choosing this option, SQL Enterprise Job Manager shows the complete list of job event alerts that belongs to a specific alert rule. Use Hide Details to display the summarized form of the alert rule.
- Dismiss - By selecting this option, SQL Enterprise Job Manager ignores the complete alert rule with their associated job alerts.
- Collect Data - By clicking this option, SQL Enterprise Job Manage gets the latest information available on the job alert.
When you choose to Show Details of a specific alert rule, you can see all job events associated with that specific alert rule. For each job event you can:
- Start Job at Step - use the drop-down options to select a specific step to start the job again.
- Dismiss - click this option to ignore the job event alert.
- Collect Data - use this option to get the latest information on the job event alert.
When you Dismiss an alert, it will not be displayed on the alerts section temporarily. SQL Enterprise Job Manager will raise the alert when the alert rule condition of the respective job event is triggered again.
Job Schedule
In this section, you can view the schedule information of your job. There is a grid list displaying your job schedule details:
- 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 the SQL Server instance where the job run.
- Job Name - Displays the name of the job.
- Message - Displays additional information about the job event.
Additionally, 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 is 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.
Keep in mind:
- You can sort the information available on this tab by clicking the column header by which you want to order your jobs.
- Click the more options icon to select the information you want to hide or show on the Job Overlap view list.
- You can define how many jobs you want to view per page. Go to the bottom section of the tab and type the number of jobs you want to see per page.
On the top right of this section, you can use the following tabs to access other job views:
- View Full Schedule - Select this option to access the Schedule tab and explore your scheduled jobs. For more information, go to Viewing your jobs on the Schedule tab.
- Job Overlap Viewer - Select this option to see which jobs are overlapped: running or scheduled to run at the same time across your registered SQL Server instances. For more information, go to Job Overlap Viewer.