Page History
...
The following table describes the details displayed for each job.
Table 11- 1 Job details table
Column | Description |
---|---|
Indicates whether the job has been changed according to the Precise for SQL Server schema change process, which runs by default once a day. | |
Job | Displays the name of the job. Each row in the table indicates a different job. |
Duration | Displays the total time that elapsed for the executions of the job, over the selected time period. |
Runs | Displays the number of job executions carried out over the selected time period. |
Job Status | Displays the current status of the job (Executing Job Step, Waiting For Thread, Between Retries, Not Running, Suspended). |
Owner | Displays the job owner, which can be one of the logins defined in the instance. |
Category | Displays the category to which the job belongs, for example, Uncategorized (Local), Database Maintenance, Replication. |
Enabled | Indicates whether the job is enabled or disabled. |
Scheduled | Indicates whether or not a job is scheduled (YES/NO). |
Warnings | Shows the warnings defined for a job. For example, if no schedule was defined for a job the following message is displayed: "No schedules were defined for this job". |
The following table shows information on the job's last run.
Table 11- 2 Last Run table
Column | Description |
---|---|
Status | Displays an icon indicating the status of the last run. Status can be one of the following: Failed, Succeeded, Retry, Canceled, In Progress. |
Job | Displays the job name. |
Last Duration | Duration of the last run. |
Date | Date of last run. |
Last Step Executed | The last step executed during the last execution of the job. |
About the Job Step entity
...
The following table shows the general job step information displayed in the Details tab.
Table 11- 3 General job step details
Column | Description |
---|---|
Indicates whether the job step has been changed according to the Precise for SQL Server schema change process, which runs by default once a day. | |
Indicates whether the current step is the first step in the job. | |
Step ID | Displays the ID of the step in the job. |
Step Name | Displays the name of the step. |
Type | The name of the subsystem used by the SQL Server Agent to execute the job step. For example, TSQL, and Replication Distributor. |
On Success | Action to perform when the execution of the step succeeds. For example, Go to next step. |
On Fail | Action to perform when the execution of the step fails For example, Quit the job when a failure is detected. |
Database | The name of the database in which the command is executed (relevant only if the subsystem is TSQL and Replication Queue Reader). |
The following table displays details of the job step's last run.
Table 11- 4 Last run tab
Column | Description |
---|---|
Indicates whether the job step has been changed according to the Precise for SQL Server schema change process, which runs by default once a day. | |
Indicates whether the current step is the first step in the job. | |
Step ID | Displays the ID of the step in the job. |
Step Name | Displays the name of the step. |
Date | The date and time the job step was last executed. |
Status | Status of the job step execution. The status can be one of the following: Failed, Succeeded, Retry, Canceled, In progress. |
Message | Displays an SQL Server error, if the job step finished with an error, and information on the step run, such as under which user the step was executed. |
Duration | Amount of time that elapsed during the last execution of the job step. |
About the Text tab
The following table displays the job step command to be executed by the subsystem.
Table 11- 5 Job Step command
Column | Description |
---|---|
Indicates whether the job step has been changed according to the Precise for SQL Server schema change process, which runs by default once a day. | |
Indicates whether the current step is the first step in the job. | |
Step ID | Displays the ID of the step in the job. |
Step Name | Displays the name of the step. |
Step Command | Displays the command to be executed by the subsystem during the current job step. |
About the Job Schedule entity
...
The following table describes the information displayed on job schedule changes.
Table 11- 6 Job Schedule Changes table
Column | Description |
---|---|
Indicates whether the job schedule has been changed according to the Precise for SQL Server schema change process, which runs, by default, once in a day. | |
Schedule | Displays the name of the job schedule. |
Enabled | Indicates whether or not the schedule is enabled (YES/NO). |
Creation Date | Displays the date the job schedule was created. |
Next Run Date | Displays the date of the next job execution. |
Schedule Details | Displays job scheduling details, such as frequency, date range, time range, and on which days of week job should be run. |
About the Job Run entity
The Job Run entity displays information on the selected Job run, such as, run date, duration, last step executed.
...
The following table describes information displayed in the Job Run table.
Table 11- 7 Job Run table
Column | Description | ||
---|---|---|---|
Date | Displays the date the job run was executed. | ||
Status | Displays an icon indicating the status of the job run (Failed, Succeeded, Retry, Canceled, In progress). | ||
Duration | Amount of time that elapsed during the execution of the job run. | ||
Last Step Executed | The last step executed in the job run. | ||
Steps Succeeded | Number of steps that were executed successfully during the job run. | ||
Steps Failed | Number of steps that failed during the job run. | ||
Message | Displays general information on the job run, such as, whether or not the job was successfully executed, which schedule executed the job run and the last step that was executed.
|
About the Job Step Run entity
...
The following table describes the information displayed in the Job Step Run table.
Table 11- 8 Job Step Run table
Column | Description |
---|---|
Date | Displays the date the selected job step run was executed. |
Status | Displays an icon that shows the status of the job step run. Status can be one of the following: Failed, Succeeded, Retry, Canceled, In progress. |
Duration | Displays the time that has elapsed during the execution of the job step run. |
Message | Displays an SQL Server error, if the job step run finished with an error, and additional information on the job step run, such as under which user the step was executed. |
About the Operators entity
...
The following table describes the information displayed in the Operators table.
Table 11- 9 Operators table
Column | Description |
---|---|
Operator | Displays the operator's name. |
Enabled | Indicates whether or not the operator can receive notifications when an alert occurs (YES/NO). |
E-mail Address | Displays the operator's e-mail address. |
Last E-Mail Date | Displays the date the operator last received an e-mail alert notification. |
Pager Address | Displays the operator's pager address. |
Last Pager Date | Displays the date the operator last received a pager alert notification. |
Net Send Address | Displays the operator's Net Send address. |
Last Net Sent Date | Displays the date the operator last received a network message. |
About the Alert Entity
The Alert entity displays information on the selected SQL Server Alert, such as alert name, error number, and E-mail notification.
...
The following table describes the information displayed in the Details table.
Table 11- 10 Details table
Column | Description |
---|---|
Alert | The name of the alert. |
Enabled | Indicates whether the alert is enabled or disabled (YES/NO). |
Error Number | Displays the number of the error that occurred. |
Severity | Displays the level of severity that triggered this alert. |
Last Occurred | Displays the last occurrence of this alert. |
Occurrences | Number of occurrences for this alert. |
Count Reset Date | Displays the date the occurrence count will be initialized to 0. |
Performance Condition | The condition that is defined on the performance counters that trigger the alert. For example, SQLServer: Access Methods|Extent Deallocations/sec||<|15. |
The following table describes the information displayed in the Notifications table
Table 11- 11 Notifications table
Column | Description |
---|---|
Alert | Displays the name of the alert. |
E-Mail Notify | Indicates whether or not an E-mail notification will be sent (YES/NO). |
Pager notify | Indicates whether or not a pager notification will be sent (YES/NO). |
Net Send Notify | Indicates whether or not a network message will be sent (YES/NO). |
Last Notification | Displays the alert's last notification date. |
Notification Message | Displays additional information sent with the alert. |
About the Database Maintenance Plan entity
...
The following table describes the information displayed in the DB Maintenance Plan table.
Table 11- 12 DB Maintenance Plan table
Column | Description |
---|---|
DB Maintenance Plan | The name of the selected DB maintenance plan. |
Creation Date | Displays the date the selected DB maintenance plan was created. |
Owner | Displays the owner of the selected DB maintenance plan. |
Databases | Displays a list of the databases associated to the selected DB maintenance plan. |
Actions | Displays a list of the actions to be performed by the selected DB maintenance plan. |
Anchor | ||||
---|---|---|---|---|
|
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance list, choose the item you want to analyze.
- On the Association controls, in the Association area, click DB Maintenance Plan.
- Drill down to a DB Maintenance Plan entity.
- On the View controls in the Main area, click Performance. Analyze how long the plan ran, during the selected time period, and try to detect any problematic periods.
- On the View controls in the Main area, click History. Observe the actions performed in the specified plan.
- Check the jobs listed in the Association area to observe how each job contributed to the entire plan and drill down to a specific job to focus on a performance problem.
Precise. Performance intelligence from click to storage. Learn more > >
...