Specifies the job schedule using crontab expressions. The associated analyze job will be run according to the crontab expression.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| analyze_job_id | integer | not null | Unique identity for the analyze job |
| time | varchar(20) | with null | Crontab expression for when the analyze job should be run |
| period | varchar(10) | with null | Textual representation of the schedule period.
- hourly - daily - weekly - monthy - quarterly - yearly |
| period_type | varchar(6) | with null | Defines the interval of the analyzis relative to the time
of the analyze job.
h - This hour H - Last hour d - Today D -Yesterday w - This week W - Last week m - This month M - Last month q - This quarter Q - Last quarter y - This year Y - Last year last30 - Last 30 days last90 - Last 90 days |
Product Name: Unicenter Service Management
Table Type: Table