Task | Required Privilege Class |
---|---|
Display information about events | Any administrator |
Set the retention period for event records | System |
Delete event records | System or unrestricted policy |
Each scheduled administrative command operation is called an event. All scheduled events, including their status, are tracked by the server. An event record is created in the server database whenever processing of a scheduled command is created or missed.
To help manage schedules for administrative commands, you can request information about scheduled and completed events. You can request general or exception reporting queries.
To minimize the processing time when querying events, minimize the time range.
To query an event for an administrative command schedule, you must specify the TYPE=ADMINISTRATIVE parameter. Figure 44 shows an example of the results of the following command:
query event * type=administrative
Figure 44. Query Results for an Administrative Schedule
+--------------------------------------------------------------------------------+ |Scheduled Start Actual Start Schedule Name Status | |-------------------- -------------------- ------------- --------- | |03/17/1997 14:08:11 03/17/1997 14:08:14 BACKUP_ARCHI- Completed | | VEPOOL | +--------------------------------------------------------------------------------+
You can specify how long event records stay in the database before the server deletes them. You can also manually remove event records from the database.
If you issue a query for events, past events may be displayed even if the event records have been deleted. The events displayed with a status of Uncertain indicate that complete information is not available because the event records have been deleted. To determine if event records have been deleted, check the message that is issued after the DELETE EVENT command is processed.
You can specify the retention period for event records in the database. After the retention period passes, the server automatically removes the event records from the database. At installation, the retention period is set to 10 days.
To set the retention period to 15 days, enter:
set eventretention 15
Event records are automatically removed from the database after both of the following conditions are met:
Because event records are deleted automatically, you do not have to manually delete them from the database. However, you may want to manually delete event records to increase available database space.
To delete all event records written prior to 11:59 p.m. on June 30, 1997, enter:
delete event type=administrative 06/30/1997 23:59