ADM_SCHEDULER_JOBS
ADM_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled jobs in the database.
|
Name |
Type |
Description |
|---|---|---|
|
owner |
name |
Owner of a scheduled job. |
|
job_name |
text |
Name of a scheduled job. |
|
job_style |
text |
Action mode of a scheduled job. |
|
job_creator |
name |
Creator of a scheduled job. |
|
program_name |
text |
Name of the program referenced by a scheduled job. |
|
job_action |
text |
Program content of a scheduled job. |
|
number_of_arguments |
text |
Number of parameters of a scheduled job. |
|
schedule_name |
text |
Name of the schedule referenced by a scheduled job. |
|
start_date |
timestamp without time zone |
Start time of a scheduled job. |
|
repeat_interval |
text |
Period of a scheduled job. |
|
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. |
|
state |
"char" |
Status of a scheduled job. |
|
failure_count |
smallint |
Number of scheduled job failures. |
|
last_start_date |
timestamp without time zone |
Last time when a scheduled job was started. |
|
next_run_date |
timestamp without time zone |
Next execution time of a scheduled job. |
|
destination |
text |
Target name of a scheduled job. |
|
credential_name |
text |
Certificate name of a scheduled job. |
|
comments |
text |
Comments of a scheduled job. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.