MY_JOBS

MY_JOBS displays all jobs owned by the 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 a job creator
priv_user	name	Username of a job executor
dbname	name	Name of the database in which a job is created
start_date	timestamp without time zone	Job start time
start_suc	text	Start time of a 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
this_date	timestamp without time zone	Start time of an ongoing job execution
this_suc	text	Start time of an ongoing successful job execution
next_date	timestamp without time zone	Schedule time of the next job execution
next_suc	text	Schedule time of the next successful job execution
broken	text	The value is y if the job state 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. Status of job step: r=running s=successfully finished f= job failed d=aborted
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