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 | Credential 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.
