<< Click to Display Table of Contents >>

Overview Jobs

Top Previous Next

 

This page currently contains two tabs: the Overview Jobs tab and the Refresh Group tab. At the bottom of the grid are two more tabs. One shows jobs of the current user, and the other jobs of all users.

Depending on which tab is selected below the grid, you see a list of all jobs either

owned by the current schema or

that the connected user is allowed to see.

The grid shows the following columns:

Job identifier. Neither import/export nor repeated executions change it.

What body of anonymous PL/SQL this job executes

Log User, i.e. USER who was logged in when the job was submitted

Priv User, i.e. USER whose default privileges apply to this job

Schema User, i.e. which schema will be applied to object references without a prefix

Last Date, i.e. date that this job was last successfully executed

Last Sec. i.e. same as Last Date. This is when the job was last successfully executed

This Date: Date that this job started executing (usually null if not executing)

This Sec: Same as This Date. This is when the job started executing

Next Date: Date that this job will next be executed

Next Sec: Same as Next Date. The job becomes due for execution at this time.

Total Time: Total wall clock time spent by the system on this job, in seconds

Broken: If Y, no attempt is being made to run this job.

Interval: A date function, evaluated at the start of execution, becomes next NEXT_DATE

Failures: How many times has this job started and failed since it last succeeded?

The following context operations are available:

JobSubmit

Submit new job

 

 

Shows a modal dialog to submit a new job.

07_Drop

Remove

 

 

Removes an existing job.

05_Properties

Change

 

 

Changes an existing job

 

Set Broken

DISABLE

True

Suspends execution of the job.

 

 

ENABLE

False

Continuous execution of the job.

QueryExecuteQuery

Run

 

 

Runs the job immediately.

 

Show DDL

 

 

Generates DDL for the selected object to a file

 

Grid View

 

 

For more information, see object window

A group box below the grid displays the following job-related initialization parameters:

Job queue processes

Job queue interval