Updated on 2025-07-15 GMT+08:00

ADM_SCHEDULER_JOBS

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

Table 1 ADM_SCHEDULER_JOBS columns

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.