MY_JOBS

MY_JOBS displays details about the scheduled tasks owned by the current user. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** MY_JOBS columns
Name	Type	Description
job	bigint	Job ID
log_user	name	Username of the job creator.
priv_user	name	Username of the job executor.
dbname	name	Name of the database where the job is created.
schema_user	name	Default schema name of a scheduler job.
start_date	timestamp without time zone	Job start time.
start_suc	text	Start time of the successful job execution.
last_date	timestamp without time zone	Start time of the last job execution.
last_suc	text	Start time of the last successful job execution.
last_sec	text	Start time of the last successful job execution. Compatibility is supported.
this_date	timestamp without time zone	Start time of the ongoing job execution.
this_suc	text	Start time of the ongoing successful job execution.
this_sec	text	Start time of an ongoing successful job execution. Compatibility is supported.
next_date	timestamp without time zone	Schedule time of the next job execution.
next_suc	text	Schedule time of the next successful job execution.
next_sec	text	Schedule time of the next successful job execution. Compatibility is supported.
total_time	numeric	Latest execution duration of a task.
broken	text	y if the job status is broken and n if otherwise.
status	"char"	Status of the current job. The value can be 'r', 's', 'f', or 'd'. The default value is 'r'. r: running s: successful execution f: failed execution d: canceling an execution
interval	text	Time expression used to calculate the next time the job will be executed. If this parameter is set to null, the job will be executed once only.
failures	smallint	Number of times the job has started and failed. If a job fails to be executed for 16 consecutive times, no more attempt will be made on it.
what	text	Executable job.
nls_env	character varying(4000)	Not supported. Set it to NULL.
misc_env	raw	Not supported. Set it to NULL.
instance	numeric	Not supported. Set it to NULL.