MY_JOBS

MY_JOBS displays details about the scheduled jobs owned by the current user. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_JOBS columns
Name	Type	Description
job	bigint	Job ID.
log_user	name	Username of a job creator.
priv_user	name	Username of a job executor.
dbname	name	Name of the database where the job is created.
schema_user	name	Default schema name of a scheduled job.
start_date	timestamp without time zone	Time when a job starts to be executed for the first time.
start_suc	text	Start time of the first 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 an ongoing job execution.
this_suc	text	Start time of an ongoing job execution.
this_sec	text	Start time of an ongoing 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 job execution.
next_sec	text	Schedule time of the next job execution. Compatibility is supported.
total_time	numeric	Latest execution duration of a job.
broken	text	If the value of the status column is 'd', the value is 'y'. Otherwise, the value is 'n'.
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. Its value is NULL.
misc_env	raw	Not supported. Its value is NULL.
instance	numeric	Not supported. Its value is NULL.