<< 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:


Submit new job



Shows a modal dialog to submit a new job.





Removes an existing job.





Changes an existing job


Set Broken



Suspends execution of the job.





Continuous execution of the job.





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