Store activity scheduler information
Data model
Fields
| Field |
Type |
Description |
| modification_date |
DATETIME |
Date of last modification |
| modified_by |
INT |
Identifier of the last user who modified the record |
| sche_application_id* |
INT |
App ID |
| sche_builtin* |
CHAR (1) |
Indicator if the schedule is predefined |
| sche_cardinal_days* |
INT |
Days of the month |
| sche_creation_date* |
DATETIME |
Schedule creation date |
| sche_description |
NVARCHAR (510) |
Description of the programme |
| sche_end_date |
DATETIME |
Date on which the schedule expires |
| sche_frecuency_type* |
NVARCHAR (100) |
How often the schedule will run |
| sche_id* |
INT |
Developer ID |
| sche_last_execution |
DATETIME |
Date of last execution |
| sche_max_delay |
INT |
Maximum delay in seconds allowed for execution |
| sche_months* |
INT |
Months of the year encoded as integer |
| sche_name* |
NVARCHAR (100) |
Schedule Name |
| sche_next_execution |
DATETIME |
Next execution date |
| sche_ordinal_days* |
INT |
Byte-encoded ordinal numbers |
| sche_parameters |
NVARCHAR (MAX) |
Parameters of the task to be executed |
| sche_recurse_every* |
INT |
Schedule Repeat Period |
| sche_start_date |
DATETIME |
Programming Start Date |
| sche_task_id* |
INT |
Scheduled action ID |
| sche_weekdays* |
INT |
Byte-encoded days of the week |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| sche_application_id* |
dbo.AFW_APPLICATIONS |
appl_id |
FK02_AFW_SCHEDULER |
| sche_task_id* |
dbo.AFW_TASKS |
task_id |
FK01_AFW_SCHEDULER |
