Page History
...
The following table describes the information displayed in the Details table.
Table 11-10 Details table
Column Description
...
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 DB Maintenance Plan entity displays information on the selected DB Maintenance Plan such as, owner, databases, and actions.
...
- Overview
- History
- Performance
About getting an overview of the database maintenance plan
The Overview displays general information on the maintenance plan. The following information is displayed:Details DB Maintenance Plan—the
- Details
- 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.
About viewing a maintenance plan's history
The History view displays a list of the actions performed by the selected maintenance plan. The following information is displayed:Action Activity
- Action. Activity performed by the selected maintenance plan. For example, Backup database, and Verify Backup.
- Start
...
- Time. Displays the date and time the action started.
- End
...
- Time. Displays the date and time the action ended.
...
- Duration. The amount of time that elapsed time during the execution of the action.
...
- Status. Status of the action (Failed, Succeeded).
...
Message. Displays a message regarding the action. For example, the message displayed for the “Backup database" action is: "Backup Destination [path]".
...
Info If the text in the Message field is cut off, hold the cursor over the Message to view the rest of the text.
...
- Error
...
- Number. Displays the error number that is reported if the action failed.
About Performance
The Performance view displays the total duration of the jobs that ere executed by the DB maintenance plan, during the selected time period.
See “Focusing on information in overtime graphs” on page 32.
About the Database Maintenance Plan entity Association area
You can view information on the entities associated with the selected DB Maintenance Plan in the Association area. It is possible to associate to the DB Maintenance Plan entity from the Instance entity.
...
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 | ||||
---|---|---|---|---|
|
...