DB 11.1: Lightweight Jobs [Video]
(Doc ID 1107773.1)
Last updated on DECEMBER 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Generic (Platform Independent)
The goal of this article is to introduce the Lightweight Jobs 11g new feature and how it can be used.
Database Administrators and Developers.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|What is a Lightweight Job?|
|Lightweight Jobs Characteristics|
Lightweight jobs have the following characteristics:
|Lightweight Jobs Restrictions|
|Persistent lightweight jobs:|
|Why lightweight jobs?|
|How to create a Lightweight Job?|
First: we need to create a program, that will be used as a template when creating the Lightweight Job:
The test_program1 is the sample program created in schema test_job.
We can create the Lightweight job based on the template program created:
We can now check USER_SCHEDULER_RUNNING_JOBS view for the status of the job similar to the regular jobs.
In the *_scheduler_jobs view, a new column has been introduced (JOB_STYLE), which shows if this is a Lightweight job or a Regular job.
|Difference in metadata:|
|The following queries will show the difference in metadata between the Lightweight jobs and the regular jobs:|
We can see that both the PURGE_LOG Regular Job and the MY_LIGHTWEIGHT_JOB1 Lightweight Job are reflected in dba_scheduler_jobs.
Now we can see that Regular Job are reflected in the DBA_OBJECTS view while the Lightweight Jobs are not.