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.
