MY_SCHEDULER_JOBS

MY_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled tasks owned by the current user in the database. By default, this view exists in the PG_CATALOG and SYS schemas and all users can access this view.

**Table 1** MY_SCHEDULER_JOBS columns
Name	Type	Description
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.