Oracle PL/SQL for DBAs

Jobs

Attribute	Datatype	Description
auto_drop	BOOLEAN	Whether the job should be dropped after having completed. Valid values are TRUE and FALSE.
comments	VARCHAR2	Comments.
end_date	TIMESTAMP	Date after which the job will no longer run. The job will be dropped if auto_drop is set or disabled, and the state is changed to COMPLETED if it is. If this attribute is set, schedule_name must be NULL.
instance_stickiness	BOOLEAN	If this is a RAC database, then the job starts on any one of the instances. The next run may be on a different instance, where the load is light. If this attribute is set to TRUE, the same instance is used, even if that is not the one with the lightest load. Valid values are TRUE and FALSE.
job_action	VARCHAR2	Nature of the program: For a PL/SQL block, specify the anonymous block to execute. For a stored procedure, specify the name of the stored procedure. You can also qualify it with a schema and package name. For an executable, specify the full path name for the operating system executable or shell script.
job_class	VARCHAR2	Job class with which this job is associated.
job_priority	PLS_INTEGER	Priority of this job relative to other jobs in the same job class. If multiple jobs within a class are scheduled to be executed at the same time, the job priority determines the order in which jobs from that class are picked up for execution by the job coordinator. Valid values are between 1 (highest priority) and 5 (lowest priority). Default is 3.