Manages a truncation schedule. rasd_trunc_schedule returns a list of the repository truncation schedule, and can also add and remove a specific schedule.
This command is available only for Oracle and Microsoft
SQL Server.
rasd_trunc_schedule [add | remove | clear | force] schedule
The day and time string in the form of restricted UNIX cron style that indicates the time automatic repository truncation is to be performed.
The following is a valid schedule string in UNIX cron style format:
[mm][HH][DOM][MON][DOW]
where:
mm – is the minutes past the hour.
HH – is the hour in 24-hour notation.
DOM – represents the days of the month, 2-digit number between 1 and 31, which represents the day of the month.
MON – represents the month of the year, abbreviated in 3-character format, such as “Jan”, “Feb”, and so on, or a 2-digit number between 1 and 12, which represents the month in a year from January to December.
DOW – represents the day of the week, abbreviated in 3-character format, such as “Sun”, “Sat”, and so on, or a 2-digit number between 1 and 7, which represents the day in a week from Sunday to Saturday.
Use an asterisk to match any valid value in a specific schedule field, ([mm],[HH],[DOM],[MON],[DOW]):
For example, “1720*** represents a daily schedule at 8:17 p.m.
When both the DOW and DOM are specified, the schedule represents two days that match either DOW or DOM.
For example, “*1216*Mon” represents 12:00 a.m. every Monday or 12:00 a.m. the 16th of every month.
Multiple entries can be provided using a semicolon.
For example, “*1216*Mon” or “1720***;*1216*Mon”.
Do not leave spaces between fields; otherwise, the schedule is rejected as an invalid schedule format.For example,“* 12 16 *Mon” is as an invalid schedule.
Use the dash “-” operator to specify a range of values. For example, “1-6” represents the sequence “1,2,3,4,5,6.”
Use the slash “/” operator to skip a given number of values. For example, “*/3” in the hour time field represents the sequence “0,3,6,9,12,15,18,21.”
To remove all repository truncation schedules, enter:
rasd_trunc_schedule clear
When the repository truncation schedule list is not set or empty, repository truncation by schedule is disabled.
To perform an immediate repository truncation manually, regardless of the automatic truncation time schedule, enter:
rasd_trunc_schedule force
rasd_trunc_schedule
This command returns a list of all repository truncation schedule times when repository truncation occurs.
rasd_trunc_schedule add, 1720***
This command adds daily repository truncation schedule at 8:17 PM to the schedule list.
rasd_trunc_schedule remove, 1720***
This command removes the daily repository truncation schedule at 8:17 PM from the schedule list.
rasd_trunc_schedule clear
This command clears all repository truncation schedules that have been set.
rasd_trunc_schedule force
This command truncates the repository immediately, regardless of the existence of any truncation schedule.
When rasd_trunc_schedule is invoked, its function is determined by the keywords and options you specify.
When you specify multiple keywords and options, separate each must using a comma. A blank space before or after a comma is optional. For example:
rasd_trunc_schedule add, 1720***
.
