Use this command to set the retention period for event records in the server database that will allow you to monitor completed schedules. An event record is created whenever processing of a scheduled command is started or missed.
You can adjust the length of time that the server maintains event information to avoid insufficient or outdated data. The server automatically removes the event records from the database after the retention period passes and the startup window for the event has elapsed.
You can issue the QUERY EVENT command to display information about scheduled and completed events.
You can issue the DELETE EVENT command to delete event records regardless of whether their retention period has passed.
You can issue the QUERY STATUS command to display the value for the event retention period. At installation, this value is set to 10 days.
Privilege class
To issue this command, you must have system privilege.
Parameters
- days (Required)
- The number of days that the database retains event records. You can specify an integer from 0 to 9999. A value of 0 indicates that only event records for the current day are retained.
Example: Set the retention period for event records
Set the retention period to 15 days.set eventretention 15Related commands
| Command | Description |
|---|---|
| DELETE EVENT | Deletes event records before a specified date and time. |
| QUERY EVENT | Displays information about scheduled and completed events for selected clients. |
| QUERY STATUS | Displays the settings of server parameters, such as those selected by the SET commands. |