ADM_SCHEDULER_JOBS
ADM_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled jobs in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
|---|---|---|
owner |
name |
Owner of a scheduled job. |
job_name |
text |
Name of a scheduled job. |
job_subname |
character varying(128) |
Not supported. Its value is NULL. |
job_style |
text |
Style of a scheduled job, which is specified during creation. Its value can only be "REGULAR". If this parameter is not specified, the value is NULL. |
job_creator |
name |
Creator of a scheduled job. |
client_id |
character varying(65) |
Not supported. Its value is NULL. |
global_uid |
character varying(33) |
Not supported. Its value is NULL. |
program_owner |
character varying(4000) |
Owner of a program referenced by a scheduled job. |
program_name |
text |
Name of the program referenced by a scheduled job. |
job_type |
character varying(16) |
Inline program type of a scheduled job. The options are as follows:
|
job_action |
text |
Program content of a scheduled job. |
number_of_arguments |
text |
Number of parameters of a scheduled job. |
schedule_owner |
character varying(4000) |
Not supported. Its value is NULL. |
schedule_name |
text |
Name of the schedule referenced by a scheduled job. |
schedule_type |
character varying(12) |
Not supported. Its value is NULL. |
start_date |
timestamp without time zone |
Start time of a scheduled job. |
repeat_interval |
text |
Period of a scheduled job. |
event_queue_owner |
character varying(128) |
Not supported. Its value is NULL. |
event_queue_name |
character varying(128) |
Not supported. Its value is NULL. |
event_queue_agent |
character varying(523) |
Not supported. Its value is NULL. |
event_condition |
character varying(4000) |
Not supported. Its value is NULL. |
event_rule |
character varying(261) |
Not supported. Its value is NULL. |
file_watcher_owner |
character varying(261) |
Not supported. Its value is NULL. |
file_watcher_name |
character varying(261) |
Not supported. Its value is NULL. |
end_date |
timestamp without time zone |
End time of a scheduled job. |
job_class |
text |
Name of the scheduled job class to which a scheduled job belongs. |
enabled |
boolean |
Status of a scheduled job. |
auto_drop |
text |
Status of the automatic deletion function of a scheduled job. |
restart_on_recovery |
character varying(5) |
Not supported. Its value is NULL. |
restart_on_failure |
character varying(5) |
Not supported. Its value is NULL. |
state |
"char" |
Status of a scheduled job. |
job_priority |
numeric |
Not supported. Its value is NULL. |
run_count |
numeric |
Not supported. Its value is NULL. |
uptime_run_count |
numeric |
Not supported. Its value is NULL. |
max_runs |
numeric |
Not supported. Its value is NULL. |
failure_count |
smallint |
Number of scheduled job failures. |
uptime_failure_count |
numeric |
Not supported. Its value is NULL. |
max_failures |
numeric |
Maximum number of failures allowed before the status of a scheduled job is marked as broken. |
retry_count |
numeric |
Not supported. Its value is NULL. |
last_start_date |
timestamp without time zone |
Last time when a scheduled job was started. |
last_run_duration |
interval day to second(6) |
Last execution duration of a scheduled job. |
next_run_date |
timestamp without time zone |
Next execution time of a scheduled job. |
schedule_limit |
interval day to second(0) |
Not supported. Its value is NULL. |
max_run_duration |
interval day to second(0) |
Not supported. Its value is NULL. |
logging_level |
character varying(11) |
Not supported. Its value is NULL. |
store_output |
character varying(5) |
Specifies whether to store the output information of all scheduled jobs |
stop_on_window_close |
character varying(5) |
Not supported. Its value is NULL. |
instance_stickiness |
character varying(5) |
Not supported. Its value is NULL. |
raise_events |
character varying(4000) |
Not supported. Its value is NULL. |
system |
character varying(5) |
Not supported. Its value is NULL. |
job_weight |
numeric |
Not supported. Its value is NULL. |
nls_env |
character varying(4000) |
Not supported. Its value is NULL. |
source |
character varying(128) |
Not supported. Its value is NULL. |
number_of_destinations |
numeric |
Not supported. Its value is NULL. |
destination_owner |
character varying(261) |
Not supported. Its value is NULL. |
destination |
text |
Target name of a scheduled job. |
credential_owner |
character varying(128) |
Not supported. Its value is NULL. |
credential_name |
text |
Certificate name of a scheduled job. |
instance_id |
oid |
OID of the current database |
deferred_drop |
character varying(5) |
Not supported. Its value is NULL. |
allow_runs_in_restricted_mode |
character varying(5) |
Not supported. Its value is NULL. |
comments |
text |
Comments of a scheduled job. |
flags |
numeric |
Not supported. Its value is NULL. |
restartable |
character varying(5) |
Not supported. Its value is NULL. |
has_constraints |
character varying(5) |
Not supported. Its value is NULL. |
connect_credential_owner |
character varying(128) |
Not supported. Its value is NULL. |
connect_credential_name |
character varying(128) |
Not supported. Its value is NULL. |
fail_on_script_error |
character varying(5) |
Not supported. Its 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
