scalingo_addonscalingo_alertscalingo_appscalingo_app_eventscalingo_autoscalerscalingo_collaboratorscalingo_containerscalingo_container_typescalingo_cronscalingo_databasescalingo_database_backupscalingo_database_maintenancescalingo_database_type_versionscalingo_database_userscalingo_deploymentscalingo_domainscalingo_environmentscalingo_event_typescalingo_invoicescalingo_keyscalingo_log_drainscalingo_log_drain_addonscalingo_notification_platformscalingo_notifierscalingo_regionscalingo_scm_integrationscalingo_scm_repo_linkscalingo_stackscalingo_tokenscalingo_user_eventscalingo_user_scm_repo_link
Table: scalingo_cron
A cron task is a command executed at a scheduled interval.
The scalingo_cron table can be used to query information about cron tasks, and you must specify which application in the where or join clause using the app_name column.
Examples
List cron tasks of an application
select commandfrom scalingo_cronwhere app_name = 'caresteouvert-api';Schema for scalingo_cron
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form. | |
| app_name | text | = | Name of the app. |
| command | text | The cron expression followed by the command. | |
| last_execution_date | timestamp with time zone | Date of the last execution. | |
| next_execution_date | timestamp with time zone | Date of the next execution. | |
| size | text | The size of the one-off container. | |
| sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
| sp_ctx | jsonb | Steampipe context in JSON form. |