rasd_trunc_schedule

(Oracle and Microsoft SQL Server only) Manages a truncation schedule. rasd_trunc_schedule returns a list of the repository truncation schedule, and can also add and remove a specific schedule.

Note: This command is available only for Oracle and Microsoft SQL Server.

Syntax

rasd_trunc_schedule [ add, schedule | remove, schedule | clear | force ]

Parameters

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.”
clear – 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.
force – To perform an immediate repository truncation manually, regardless of the automatic truncation time schedule, enter:
```
rasd_trunc_schedule force
```

Examples

Example 1 –
```
rasd_trunc_schedule
```
This command returns a list of all repository truncation schedule times when repository truncation occurs.
Example 2 –
```
rasd_trunc_schedule add, 1720***
```
This command adds daily repository truncation schedule at 8:17 PM to the schedule list.
Example 3 –
```
rasd_trunc_schedule remove, 1720***
```
This command removes the daily repository truncation schedule at 8:17 PM from the schedule list.
Example 4 –
```
rasd_trunc_schedule clear
```
This command clears all repository truncation schedules that have been set.
Example 5 –
```
rasd_trunc_schedule force
```
This command truncates the repository immediately, regardless of the existence of any truncation schedule.

Usage

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***
```