GaussDB-MY_SCHEDULER_JOBS
MY_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled tasks owned by the current user in the database. By default, this view exists in the PG_CATALOG and SYS schemas and all users can access this view.
| Name | Type | Description |
|---|---|---|
| job_name | text | Name of a scheduler job. |
| job_subname | character varying(128) | Not supported. Set it to NULL. |
| job_style | text | Action mode of a scheduler job. |
| job_creator | name | Creator of a scheduler job. |
| client_id | character varying(65) | Not supported. Set it to NULL. |
| global_uid | character varying(33) | Not supported. Set it to NULL. |
| program_owner | character varying(4000) | Owner of a program referenced by a scheduler job. |
| program_name | text | Name of the program referenced by a scheduler job. |
| job_type | character varying(16) | Type of the inline program of a scheduler job. |
| job_action | text | Program content of a scheduler job. |
| number_of_arguments | text | Number of parameters of a scheduler job. |
| schedule_owner | character varying(4000) | Not supported. Set it to NULL. |
| schedule_name | text | Name of the schedule referenced by a scheduler job. |
| schedule_type | character varying(12) | Not supported. Set it to NULL. |
| start_date | timestamp without time zone | Start time of a scheduler job. |
| repeat_interval | text | Period of a scheduler job. |
| event_queue_owner | character varying(128) | Not supported. Set it to NULL. |
| event_queue_name | character varying(128) | Not supported. Set it to NULL. |
| event_queue_agent | character varying(523) | Not supported. Set it to NULL. |
| event_condition | character varying(4000) | Not supported. Set it to NULL. |
| event_rule | character varying(261) | Not supported. Set it to NULL. |
| file_watcher_owner | character varying(261) | Not supported. Set it to NULL. |
| file_watcher_name | character varying(261) | Not supported. Set it to NULL. |
| end_date | timestamp without time zone | End time of a scheduler job. |
| job_class | text | Name of the scheduler job class to which a scheduler job belongs. |
| enabled | boolean | Status of a scheduler job. |
| auto_drop | text | Status of the automatic deletion function of a scheduler job. |
| restart_on_recovery | character varying(5) | Not supported. Set it to NULL. |
| restart_on_failure | character varying(5) | Not supported. Set it to NULL. |
| state | "char" | Status of a scheduler job. |
| job_priority | numeric | Not supported. Set it to NULL. |
| run_count | numeric | Not supported. Set it to NULL. |
| uptime_run_count | numeric | Not supported. Set it to NULL. |
| max_runs | numeric | Not supported. Set it to NULL. |
| failure_count | smallint | Number of scheduler job failures. |
| uptime_failure_count | numeric | Not supported. Set it to NULL. |
| max_failures | numeric | Maximum number of failures allowed before the status of a scheduler job is marked as broken. |
| retry_count | numeric | Not supported. Set it to NULL. |
| last_start_date | timestamp without time zone | Last time when a scheduler job was started. |
| last_run_duration | interval day to second(6) | Last execution duration of a scheduler job. |
| next_run_date | timestamp without time zone | Next execution time of a scheduler job. |
| schedule_limit | interval day to second(0) | Not supported. Set it to NULL. |
| max_run_duration | interval day to second(0) | Not supported. Set it to NULL. |
| logging_level | character varying(11) | Not supported. Set it to NULL. |
| store_output | character varying(5) | Specifies whether to store the output information of all scheduler jobs. |
| stop_on_window_close | character varying(5) | Not supported. Set it to NULL. |
| instance_stickiness | character varying(5) | Not supported. Set it to NULL. |
| raise_events | character varying(4000) | Not supported. Set it to NULL. |
| system | character varying(5) | Not supported. Set it to NULL. |
| job_weight | numeric | Not supported. Set it to NULL. |
| nls_env | character varying(4000) | Not supported. Set it to NULL. |
| source | character varying(128) | Not supported. Set it to NULL. |
| number_of_destinations | numeric | Not supported. Set it to NULL. |
| destination_owner | character varying(261) | Not supported. Set it to NULL. |
| destination | text | Target name of a scheduler job.If the value of destination is CCN, the task is a CCN job. For details, see DBE_SCHEDULER. |
| credential_owner | character varying(128) | Not supported. Set it to NULL. |
| credential_name | text | Certificate name of a scheduler job. |
| instance_id | oid | OID of the current database. |
| deferred_drop | character varying(5) | Not supported. Set it to NULL. |
| allow_runs_in_restricted_mode | character varying(5) | Not supported. Set it to NULL. |
| comments | text | Comments of a scheduler job. |
| flags | numeric | Not supported. Set it to NULL. |
| restartable | character varying(5) | Not supported. Set it to NULL. |
| has_constraints | character varying(5) | Not supported. Set it to NULL. |
| connect_credential_owner | character varying(128) | Not supported. Set it to NULL. |
| connect_credential_name | character varying(128) | Not supported. Set it to NULL. |
| fail_on_script_error | character varying(5) | Not supported. Set it to NULL. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
