Use this command to delete event records from the database. An event record is created whenever processing of a scheduled command is started or missed.
This command only deletes the event records that exist at the time the command is processed. An event record will not be found if the event record has never been created (the event is scheduled for the future) or if the event has passed and the event record has already been deleted.
Privilege Class
To issue this command, you must have system privilege or unrestricted policy privilege.
Syntax
.-00:00--. >>-DELete EVent--date----+------+-------------------------------> '-time-' .-TYPE--=--Client-------------. >-----+-----------------------------+-------------------------->< '-TYPE--=--+-Client---------+-' +-ADministrative-+ '-ALl------------'
Parameters
Use this parameter in conjunction with the TIME parameter to specify a date and time for deleting event records. Any record whose scheduled start occurs before the specified date and time is deleted. However, records are not deleted for events whose startup window has not yet passed.
You can specify the data using one of the values below:
Value | Description | Example |
---|---|---|
MM/DD/YYYY | A specific date | 09/15/1998 |
TODAY | The current date | TODAY |
TODAY-days or -days | The current date minus days specified | TODAY-3 or -3. |
You can specify the data using one of the values below:
Value | Description | Example | ||
---|---|---|---|---|
HH:MM:SS | A specific time | 10:30:08 | ||
NOW | The current time | NOW | ||
NOW+HH:MM or +HH:MM | The current time plus hours and minutes specified | NOW+03:00 or +03:00
| ||
NOW-HH:MM or -HH:MM | The current time minus hours and minutes specified | NOW-03:00 or -03:00 |
Examples
Task
Delete records for events with scheduled start times prior to 08:00 on May 26, 1998 (05/26/1998), and whose startup window has passed. Records for these events are deleted regardless of whether the retention period for event records, as specified with the SET EVENTRETENTION command, has passed.
Related Commands
Table 92. Commands Related to DELETE EVENT
Command | Description |
---|---|
QUERY EVENT | Displays information about scheduled and completed events for selected clients. |
SET EVENTRETENTION | Specifies the number of days to retain records for scheduled operations. |