MY_SCHEDULER_JOBS

job_name

text

Name of a scheduler job.

job_subname

character varying(128)

Not supported. Set it to 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. Set it to NULL.

global_uid

character varying(33)

Not supported. Set it to 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. Set it to NULL.

schedule_name

text

Name of the schedule referenced by a scheduler job.

schedule_type

character varying(12)

Not supported. Set it to 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. Set it to NULL.

event_queue_name

character varying(128)

Not supported. Set it to NULL.

event_queue_agent

character varying(523)

Not supported. Set it to NULL.

event_condition

character varying(4000)

Not supported. Set it to NULL.

event_rule

character varying(261)

Not supported. Set it to NULL.

file_watcher_owner

character varying(261)

Not supported. Set it to NULL.

file_watcher_name

character varying(261)

Not supported. Set it to 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. Set it to NULL.

restart_on_failure

character varying(5)

Not supported. Set it to NULL.

state

"char"

Status of a scheduler job.

job_priority

numeric

Not supported. Set it to NULL.

run_count

numeric

Not supported. Set it to NULL.

uptime_run_count

numeric

Not supported. Set it to NULL.

max_runs

numeric

Not supported. Set it to NULL.

failure_count

smallint

Number of scheduler job failures.

uptime_failure_count

numeric

Not supported. Set it to 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. Set it to 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. Set it to NULL.

max_run_duration

interval day to second(0)

Not supported. Set it to NULL.

logging_level

character varying(11)

Not supported. Set it to 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. Set it to NULL.

instance_stickiness

character varying(5)

Not supported. Set it to NULL.

raise_events

character varying(4000)

Not supported. Set it to NULL.

system

character varying(5)

Not supported. Set it to NULL.

job_weight

numeric

Not supported. Set it to NULL.

nls_env

character varying(4000)

Not supported. Set it to NULL.

source

character varying(128)

Not supported. Set it to NULL.

number_of_destinations

numeric

Not supported. Set it to NULL.

destination_owner

character varying(261)

Not supported. Set it to NULL.

destination

text

Target name of a scheduler job.

If the value of destination is CCN, the task is a CCN job. For details, see DBE_SCHEDULER.

credential_owner

character varying(128)

Not supported. Set it to 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. Set it to NULL.

allow_runs_in_restricted_mode

character varying(5)

Not supported. Set it to NULL.

comments

text

Comments of a scheduler job.

flags

numeric

Not supported. Set it to NULL.

restartable

character varying(5)

Not supported. Set it to NULL.

has_constraints

character varying(5)

Not supported. Set it to NULL.

connect_credential_owner

character varying(128)

Not supported. Set it to NULL.

connect_credential_name

character varying(128)

Not supported. Set it to NULL.

fail_on_script_error

character varying(5)

Not supported. Set it to NULL.