Page History
...
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
...
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 Job Step entity displays information on the selected Job step. While Job Step performance information is also available in the Activity tab, the Maintenance tab displays additional information, such as, configuration parameters, what action to perform when the current step has succeeded, in addition to performance information on the job step runs. Unlike the Activity tab, where the source of information is the Precise for SQL Server Collector, the information displayed in the Maintenance tab is retrieved directly from SQL Server.
...
- Overview
- Command
- Job Step Changes
About getting an overview of a job step
The Overview displays information on the selected job step along with information on its last run and job step runs, over the selected time period.Details Step Name—displays
- Details
- Step Name. Displays the name of the step.
- Step
...
- ID. Displays the step ID.
- Job.
...
- Displays the name of the step's job.
...
- Owner. Displays the owner of the step's job.
...
- Category. Displays the category of the selected job step. For example, a job step can be categorized as “Database Maintenance”.
...
- Type. Displays the name of the subsystem used by SQL Server Agent to execute the job step (for example, TSQL, and Replication Distributor.).
- Sample
...
- Date. The estimated last change date of one of the job step details. The change is reported by the Precise for SQL Server Schema Change Process, which runs, by default, once a day. In other words, the Sample Date is actually the date the schema change process was executed.
...
- Action. Displays configuration information regarding step execution.
- 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.
...
- Retry. Number of retry attempts to perform if the step fails.
- Retry
...
- Intervals. Amount of time to wait between retry attempts.
- Last
...
- run. Displays information on the last execution of the Job Step.
...
- Date. Date of the last run.
...
- Duration. The duration of the last run.
...
- Status. Displays the status of the last run. 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, in addition to information on the step run, such as under which user the step was executed. (Note: if the text in the Message field is cut off, hold the cursor over the Message to view the rest of the text.)
- In MS-SQL
...
- graph. Displays resource consumption for the job step over a specified time frame.
- Run history
...
- graph. Displays the number of job executions versus duration, over the selected time period.
About viewing the command executed by a subsystem
The Command view displays the command to be executed by the subsystem during the current job step.
About viewing Job Step changes
The Job Step Changes view displays the Job Step changes that were carried out during the specified time frame, as follows:
- Data
...
- Changed. Displays the data that was changed (such as, command text, and what action to perform in case of failure).
- Old
...
- Value. The value before the change.
- New
...
- Value. The value following the change.
- Change
...
- Date. The estimated change date. The change is reported by the Precise for SQL Server schema change process, which runs, by default, once a day. In other words, the Change Date is actually the date the schema change process was executed (or the sample date).
The following job step details are monitored by the Collect Schema Changes process:
- Sub System Name
- Command Text
- On Success Action
- On Success Next Step
- On Fail Action
- On Fail Next Step
- Database Name
- Database User Name
- Retry Attempts
- Retry Interval
About the Job Step entity Association area
You can view information on the entities associated with the selected Job Step entity in the Association area. It is possible to associate to the Job Step entity from the Job entity.
...
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
...
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
...
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 Job Schedule entity displays scheduling information for the selected Job, such as schedule details, and next run date.
...
- Overview
- Job Schedule Changes
About getting an overview of a job schedule
The Overview displays the following Job Schedule details:Job Displays
- Job. Displays the name of the job.
...
- 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 days in week to run the job.
- Sample
...
- Date. The estimated last change date of one of the job schedule details. The change is reported by the Precise for SQL Server schema change process, which runs, by default, once a date. In other words, the Sample Date is actually the date the schema change process was executed.
About viewing Job schedule changes
The Job Schedule Changes view displays the Job Schedule changes that were carried out during the selected time frame, as follows:
- Data
...
- Changed. The data that was changed.
- Old
...
- Value. The value before the change.
- New
...
- Value. The value following the change.
- Change
...
- Date. The estimated change date. The change is reported by the Precise for SQL Server schema change process, which runs, by default, once a day. In other words, the Change Date is actually the date the schema change process was executed (or the sample date).
The following job schedule details are monitored by the Collect Schema Changes process:
- Enabled
- Schedule Details
About the Job Schedule entity Association area
You can view information on the entities associated with the selected Job Schedule Changes entity in the Association area. It is possible to associate to the Job Schedule Changes entity from the Job entity.
...
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.
About getting an overview of a job run
The Overview displays general information on the Job Run.Details Job—displays
- Details
- Job. Displays the job name.
...
- Owner. Displays the job's owner.
...
- Category. Displays the category of the selected job run. For example, a job run can be categorized as “Database Maintenance”.
...
- Run
- Date. The
...
- date the selected job run was executed.
...
- Duration. Amount of time that has elapsed while the selected job run was executed.
- Status.
...
- Displays the status of the job run (Failed, Succeeded, Retry, Canceled, In progress).
...
- Message. Displays general job run information, such as whether or not the job was successful, which schedule executed the job run, and the last step that was executed. (Note: if the text in the Message field is cut off, hold the cursor over the Message to view the rest of the text.)
- Last Step
...
- Executed. The last step executed in the selected job run.
- Steps
...
- Chain. Displays the step ID of all the steps executed in the selected job run in the order of their execution time. A plus sign (+) or minus sign (-) follows each step ID indicating whether or not the step was successful. Plus (+) indicates that the step was executed successfully; Minus (-) indicates that the step's execution failed.
About the Job Run entity Association area
You can view information on the entities associated with the selected Job Run entity in the Association area. It is possible to associate to the Job Run entity from the Job entity.
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 Job Step Run entity displays information on the selected Job Step Run, such as, run date, duration of execution, and status.
The following views are available:
- Overview
- Command
About getting an overview of a job step run
The Overview displays general information on the Job Step Run, as follows:Details Step Name—displays
- Details
- Step Name. Displays the step name.
- Step
...
- ID. Displays the step ID.
- Job.
...
- The name of the step's job.
...
- Owner. The owner of the step's job.
...
- Category. Displays the category of the selected job run. For example, a job run can be categorized as “Database Maintenance”.
...
- Type. The name of the subsystem used by SQL Server Agent to execute the job step. For example: TSQL, and Replication Distributor.
...
- Run
- Date. The date the selected job step run was executed.
...
- Duration. Amount of time that elapsed during the execution of the selected job step run.
- Status.
...
- Status of the job step run (Failed, Succeeded, Retry, Canceled, In progress).
...
Message. Displays an SQL Server error if the job step run finished with an error, and additional information, such as indicating under which user the step was executed.
...
Info if the text in the Message field is cut off, hold the cursor over the Message to view the rest of the text.
...
About Command
The Command view displays the command to be executed by the subsystem during the current job step run.Note:
Info |
---|
The command displayed is the command currently saved in the production system table. If you change the command after this step is run you will not be observing the command that was actually executed. To view the command that was actually executed, check the Job Step Changes view for the specified step. |
About the Job Step Run entity Association area
You can view information on the entities associated with the selected Job Step Run entity in the Association area. It is possible to associate to the Job Step Run entity from the Job Run and Job Step entities.
...
Table 11-8 Job Step Run table
Column Description
...
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 Operator entity displays information on the selected Operator, such as operator name, E-mail address, and pager address.
About getting an overview of a selected Operator
The Overview displays the following general details on the Operator. The following information is displayed:Details Operator—displays
- Details
- Operator. Displays the operator's name.
...
- Enabled. Indicates whether or not the operator can receive notifications when an alert occurs (YES/NO).
...
- 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 Operators entity Association area
You can view information on the entities associated with the selected Operators entity in the Association area. It is possible to associate to the Operators entity from the Instance and Alert entities.
...
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). |
...
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.
About getting general information on an SQL Server Alert
The Overview displays general information on the Alert. The following information is displayed:Details Alert—displays
- Details
- Alert. Displays 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.
...
- Occurrences. Number of occurrences for this alert.
- Last
...
- Occurred. Displays the last occurrence of this alert.
- Count Reset
...
- Date. Displays the date the occurrence count will be initialized to 0.
- Performance
...
- Condition. The condition that is defined in the performance counter that triggers the alert. For example, SQLServer: Access Methods|Extent Deallocations/sec||<|15.
- Notification
...
...
- 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 SQL Server Alert Association area
You can view information on the entities associated with the selected Alert Entity in the Association area. It is possible to associate to the Alert entity the Instance entity.
...