Page History
...
The entities displayed in the Association area are associated with the selected entity displayed in the Main area. At times, the relationship between the entity displayed in the Main area and those displayed in the Association area is that of parent to child and sometimes it merely represents that there is a relationship between the selected entity and the entities displayed in the Association area.
About the Main area in the Maintenance tab
The Main area shows comprehensive information on the selected parent entity. You can choose from several views to examine the entity from different angles. You can, for example, focus exclusively on Jobs data (default), or view data on database maintenance plans or alerts.
About the Association area in the Maintenance tab
The Association area provides corresponding information on the child entities. You can view information on one type of child entity at a time, such as jobs or database maintenance plans, by selecting a control from the Association Controls list. The selection you make is reflected in the Association area only; the Main area remains unchanged. For some entities, tabs above the Association area enable you to view additional information: Clicking a tab changes the table columns for the same type of child entities.
...
- Instance Entity
- Job Entity
- Job Step Entity
- Job Schedule Entity
- Job Run Entity
- Job Step Run Entity
- Operators Entity
- Alert Entity
- Database Maintenance Plan Entity
About the Instance Entity
The Instance entity displays DBA-related information on the monitored SQL Server instance, in the following views:
- Overview
- Job Changes
About getting an overview of the OS and SQL Server instance
The Overview displays general information on the OS and the SQL Server instance. In addition, the status of the Agent (SQL Server Agent, Microsoft search and Distributed transaction coordinator) is reported.
About viewing which Job changes were carried out during a selected time period
The Job view displays the job changes that were carried out during the selected time period. The changes can occur in the job itself, and in the job's steps and schedule details.
The following information is displayed:
- Name Name Name. Name of the job that was changed.
- Change Type Type Type. Type of change. The following types of changes are reported—Dropped, Created, Changed. Any change in a job's steps is reported as “Changed”, including Create and Drop.
- Change Date The 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).
About the Job Entity
The Job entity displays information on the selected job. While job performance information is also available in the Activity tab, the Maintenance tab displays additional information, such as, configuration parameters and scheduling, as well as performance information on the job 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 the SQL Server.
...
- Overview
- Notifications
- Job Changes
About getting an overview of the selected job
The Overview displays information on the selected job along with information on its last run and job runs, over the selected time period, as follows:
- Details Displays Details. Displays the following job details:
- Job—displays Job. Displays the job name.
- Category—displays Category. Displays the category of the selected job. For example, a job can be categorized as “Database Maintenance”.
- Enabled—indicates Enabled. Indicates whether the job is enabled or disabled.
- Scheduled—indicates Scheduled. Indicates if there is at least one schedule for the job.
- Description—displays Description. Displays the job description entered by the job's creator.
- Last Run Displays Run. Displays information related to the last execution of the job.
The following information is displayed:- Date. Displays the date of the last run.
- Last
- Duration. Displays 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.
- Last Step
- Executed. Displays the last step executed during the last execution of the job.
- In MS SQL graph graph. Displays the job's resource consumption over time, within the selected time frame.
- Run history graph Displays graph. Displays the number of job executions versus duration over the selected time period.
About viewing a job configuration to send notifications
A job can be configured to notify various messages when it completes its run. The Notifications view displays how the job has been configured to send its various notification messages.
The following information is displayed:Operators E
- Operators
...
- Operator. E-mail address of the operator to notify.
- Page
...
- Operator. Computer or user ID used when sending a page.
- Net Send
...
- Operator. Computer or user ID used when sending network messages.
- Write to Windows Application
...
- Log. Indicates whether notification will be sent to the event log (YES/NO).
- Delete
...
- Job. Indicates whether the job should be deleted when it is completed (YES/NO).
- Notifications
...
...
- Notify. Indicates whether a notification e-mail should be sent, when the job is completed. The following values are available:
- Notify. Indicates whether a notification e-mail should be sent, when the job is completed. The following values are available:
...
- Never. Notification will never be sent after the job is completed.
When the job succeeds.
When the job fails.
Whenever the job completes (regardless of the job outcome).
- Never. Notification will never be sent after the job is completed.
- Page
...
- Notify. Indicates whether a notification page should be sent, when the job is completed. The following values are available:
- Notify. Indicates whether a notification page should be sent, when the job is completed. The following values are available:
...
- Never. Notification should never be sent after the job is completed.
When the job succeeds.
When the job fails.
Whenever the job completes (regardless of the job outcome).
- Never. Notification should never be sent after the job is completed.
- Net Send
...
- Notify. Indicates whether a network message should be sent, when the job is completed. The following values are available:
- Notify. Indicates whether a network message should be sent, when the job is completed. The following values are available:
...
- Never. Notification should never be sent after the job is completed.
When the job succeeds.
When the job fails.
Whenever the job completes (regardless of the job outcome).
- Never. Notification should never be sent after the job is completed.
- Write
...
- Notify. Indicates whether a notification event should be logged to the
...
- Microsoft Windows
...
- NT application log, when the job is completed. The following values are available:
- NT application log, when the job is completed. The following values are available:
...
- Never. The job should never be deleted.
When the job succeeds.
When the job fails.
Whenever the job completes (regardless of the job outcome).
- Never. The job should never be deleted.
- Delete
...
- Notify. Indicates whether or not the job should be deleted when the job is completed.
About viewing job changes, schedules and step changes
The Job Changes view displays the job changes and job schedules and step changes that were performed over the selected time period. The following information is displayed:Type The
- Type. The type of object that was changed—Job, Job step, Job schedule.
- Name.
...
- Name of the object.
- Change
...
- Type. Type of change. The following types of changes are reported—Dropped, Created, Changed.
- Data
...
- Changed. The data that was changed (such as, schedule details, command text.)
- 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 details are monitored by the Collect Schema Changes process:
- Enabled
- Category name
- Owner
- Start step name
- E-mail notify
- Page notify
- Net send notify
- Event log notify
- E-mail operator
- Page operator
- Net send operator
- Delete level
About the Job entity Association area
You can view information on the entities associated with the selected Job entity in the Association area. It is possible to associate to the Job entity from the Instance, DB Maintenance Plan, Operator and Alert entities.
...