ADM_SCHEDULER_JOBS
ADM_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduler 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 the PG_CATALOG and SYS schemas.
Name |
Type |
Description |
|---|---|---|
owner |
name |
Owner of a scheduler job. |
job_name |
text |
Name of a scheduler job. |
job_subname |
character varying(128) |
Not supported. Its value is NULL. |
job_style |
text |
Action mode of a scheduler job. It 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 scheduler 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 scheduler job. |
program_name |
text |
Name of the program referenced by a scheduler job. |
job_type |
character varying(16) |
Inline program type of a scheduled task. The options are as follows:
|
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. Its value is NULL. |
schedule_name |
text |
Name of the schedule referenced by a scheduler job. |
schedule_type |
character varying(12) |
Not supported. Its 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. 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 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. Its value is NULL. |
restart_on_failure |
character varying(5) |
Not supported. Its value is NULL. |
state |
"char" |
Status of a scheduler 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 scheduler 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 scheduler 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 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. 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 scheduler 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 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. Its 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. Its value is NULL. |
allow_runs_in_restricted_mode |
character varying(5) |
Not supported. Its value is NULL. |
comments |
text |
Comments of a scheduler 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
