Table Type: System Configuration
This table contains one-off commands to be run, have already been run, or are in progress.
To give CX Vizz a one-off command, you should fill in the table with an action, provide a GUID, and leave all fields blank.
The status and messages fields will update automatically as the command is executed.
To re-run a command again, set the Status field to 'Idle' or null.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| key | guid | Primary Key, Required | |
| command | string | The command to run. This is a sequence of actions, which may include stored procedures. | |
| when_started | datetime | The time the command was started. Null if not yet started. | |
| when_finished | datetime | The time the command ended. Null if not yet finished. | |
| message | string | The last message issued by the command, or an error message | |
| status | jobstatus | The status of the command. Idle or NULL means it has not yet been run. Running means it is currently being run. Finished means it has been run. Failed means an error occurred. | |
| last_heartbeat | datetime | Required | The last time the command issued a heartbeat signal, this is used internally to monitor the execution of the action |