MY_SCHEDULER_JOBS
MY_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled tasks owned by the current user in the database. By default, it is accessible to all users. This view exists in the PG_CATALOG and SYS schemas.
|
Name |
Type |
Description |
|---|---|---|
|
job_name |
text |
Name of a scheduler job. |
|
job_subname |
character varying(128) |
Not supported. The value is 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. The value is NULL. |
|
global_uid |
character varying(33) |
Not supported. The value is 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. The value is NULL. |
|
schedule_name |
text |
Name of the scheduler referenced by a scheduler job. |
|
schedule_type |
character varying(12) |
Not supported. The value is 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. The value is NULL. |
|
event_queue_name |
character varying(128) |
Not supported. The value is NULL. |
|
event_queue_agent |
character varying(523) |
Not supported. The value is NULL. |
|
event_condition |
character varying(4000) |
Not supported. The value is NULL. |
|
event_rule |
character varying(261) |
Not supported. The value is NULL. |
|
file_watcher_owner |
character varying(261) |
Not supported. The value is NULL. |
|
file_watcher_name |
character varying(261) |
Not supported. The value is 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. The value is NULL. |
|
restart_on_failure |
character varying(5) |
Not supported. The value is NULL. |
|
state |
"char" |
Status of a scheduler job. |
|
job_priority |
numeric |
Not supported. The value is NULL. |
|
run_count |
numeric |
Not supported. The value is NULL. |
|
uptime_run_count |
numeric |
Not supported. The value is NULL. |
|
max_runs |
numeric |
Not supported. The value is NULL. |
|
failure_count |
smallint |
Number of scheduler job failures. |
|
uptime_failure_count |
numeric |
Not supported. The value is 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. The value is 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. The value is NULL. |
|
max_run_duration |
interval day to second(0) |
Not supported. The value is NULL. |
|
logging_level |
character varying(11) |
Not supported. The value is 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. The value is NULL. |
|
instance_stickiness |
character varying(5) |
Not supported. The value is NULL. |
|
raise_events |
character varying(4000) |
Not supported. The value is NULL. |
|
system |
character varying(5) |
Not supported. The value is NULL. |
|
job_weight |
numeric |
Not supported. The value is NULL. |
|
nls_env |
character varying(4000) |
Not supported. The value is NULL. |
|
source |
character varying(128) |
Not supported. The value is NULL. |
|
number_of_destinations |
numeric |
Not supported. The value is NULL. |
|
destination_owner |
character varying(261) |
Not supported. The value is NULL. |
|
destination |
text |
Target name of a scheduler job. |
|
credential_owner |
character varying(128) |
Not supported. The value is 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. The value is NULL. |
|
allow_runs_in_restricted_mode |
character varying(5) |
Not supported. The value is NULL. |
|
comments |
text |
Comments of a scheduler job. |
|
flags |
numeric |
Not supported. The value is NULL. |
|
restartable |
character varying(5) |
Not supported. The value is NULL. |
|
has_constraints |
character varying(5) |
Not supported. The value is NULL. |
|
connect_credential_owner |
character varying(128) |
Not supported. The value is NULL. |
|
connect_credential_name |
character varying(128) |
Not supported. The value is NULL. |
|
fail_on_script_error |
character varying(5) |
Not supported. The value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
