Table Type: System Configuration
Contains a list of all the scheduled jobs. It contains next_run_time and last_run_time so you can check when it last ran, and when it will run next.
The job_schedule_action table contains all the actions that will be run as part of this job, one after the other in order.
If you wish to perform two different actions concurrently, you should create two jobs each with their own list of actions to carry out.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| key | guid | Primary Key, Required | |
| cron_expression | string | The cron expression that defines when the job will run. [Minute] [Hour] [Day-of-month] [Month] [Day-of-week] | |
| description | string | ||
| last_run_time | datetime | When the job last ran in UTC | |
| next_run_time | datetime | When the job will next run in UTC | |
| status | jobstatus | Idle, Cancelled, Completed, Disabled, Executing, Failed, Scheduled, or Starting. | |
| disabled_reason | string | ||
| last_heartbeat | datetime | Required | The last time the command issued a heartbeat signal, thisis used internally to monitor the execution of the action |