This table is used to record the set of scheduled
jobs to be executed against each subscription or a recurring order,
as specified by the shopper. Typically, jobs for cancellation of
subscriptions, creation of the next child order, expiry of
subscriptions after the end date are stored in this table.
Column Descriptions:
| Name | Type | Description |
| SCHEDULED_ID | BIGINT NOT NULL | Generated unique key. |
| ACTIONDATE | TIMESTAMP NOT NULL | The date when this scheduled job is to be
executed by the scheduler. |
| SUBSCRIPTION_ID | BIGINT NOT NULL | The ID of the subscription or recurring order for
which this scheduled job needs to be executed. |
| ACTION | VARCHAR (32) NOT NULL | The scheduled job to be executed by the
subscription scheduler
- CreateChildOrder
- Cancel
- Expire
|
| TIMEPLACED | TIMESTAMP NOT NULL | The time when this scheduled job was created by
the subscription component |
| LASTUPDATE | TIMESTAMP NOT NULL | The time when this scheduled job record was last
updated by the subscription scheduler. |
| STATUS | INTEGER NOT NULL | Current status of the scheduled job
- 0- ACTIVE
- 2- FAILED
- 3- COMPLETED
- 4- RETRY
- 5- PROCESSING
|
| PARAMETER | VARCHAR (254) | Parameters to be used by the subscription
scheduler while executing a scheduled job. Typically used by jobs
to store the last successful state of the job, in case of
multi-step job execution process. This data is then used during the
job recovery and retry process. |
| FIELD1 | INTEGER | Customizable |
| FIELD2 | DECIMAL (20,5) | Customizable |
| FIELD3 | VARCHAR (254) | Customizable |
| RETRYCOUNT | INTEGER | The number of times this job was attempted due to
failure. This value is checked against the maximum retry count
specified for every job in the subscription component
configuration. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | SCHEDULED_ID | Primary Key |
| I0001371 | SUBSCRIPTION_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3659 | SUBSCRIPTION_ID | SUBSCRIPTION | SUBSCRIPTION_ID | Cascade |