Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.42 USER_JOBS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.42 USER_JOBS

The USER_JOBS view provides information about all jobs owned by the current user.

Name

Type

Description

job

INTEGER

The identifier of the job (Job ID).

log_user

TEXT

The name of the user that submitted the job.

priv_user

TEXT

Same as log_user. Included for compatibility only.

schema_user

TEXT

The name of the schema used to parse the job.

last_date

TIMESTAMP WITH TIME ZONE

The last date that this job executed successfully.

last_sec

TEXT

Same as last_date.

this_date

TIMESTAMP WITH TIME ZONE

The date that the job began executing.

this_sec

TEXT

Same as this_date

next_date

TIMESTAMP WITH TIME ZONE

The next date that this job will be executed.

next_sec

TEXT

Same as next_date.

total_time

integer

The execution time of this job (in seconds).

broken

TEXT

If Y, no attempt will be made to run this job.

If N, this job will attempt to execute.

interval

TEXT

Determines how often the job will repeat.

what

TEXT

The job definition (PL/SQL code block) that runs when the job executes.

failures

BIGINT

The number of times that the job has failed to complete since it’s last successful execution.

nls_env

VARCHAR2(4000)

Always NULL. Provided for compatibility only.

misc_env

BYTEA

Always NULL. Provided for compatibility only.

instance

NUMERIC

Always 0. Provided for compatibility only.

Previous PageTable Of ContentsNext Page