Updated on 2023-10-23 GMT+08:00

ADM_SCHEDULER_JOBS

ADM_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled tasks in the database.

Table 1 ADM_SCHEDULER_JOBS columns

Name

Type

Description

owner

name

Owner of a scheduled task.

job_name

text

Name of a scheduled task.

job_style

text

Action mode of a scheduled task.

job_creator

name

Creator of a scheduled task.

program_name

text

Name of the program referenced by a scheduled task.

job_action

text

Program content of a scheduled task.

number_of_arguments

text

Number of parameters of a scheduled task.

schedule_name

text

Name of the schedule referenced by a scheduled task.

start_date

timestamp without time zone

Start time of a scheduled task.

repeat_interval

text

Period of a scheduled task.

end_date

timestamp without time zone

End time of a scheduled task.

job_class

text

Name of the scheduled task class to which a scheduled task belongs.

enabled

boolean

Status of a scheduled task.

auto_drop

text

Status of the automatic deletion function of a scheduled task.

state

"char"

Status of a scheduled task.

failure_count

smallint

Number of scheduled task failures.

last_start_date

timestamp without time zone

Last time when a scheduled task was started.

next_run_date

timestamp without time zone

Next execution time of a scheduled task.

destination

text

Target name of a scheduled task.

credential_name

text

Certificate name of a scheduled task.

comments

text

Comments of a scheduled task.