Alter a job task - SETATTRIBUTE procedure - Oracle DBA

Discussion

• Nirja Shah   -Posted on 25 Aug 15
  -The SET_ATTRIBUTE procedure changes an attribute of an object.
  -It is overloaded to accept values of the following types: VARCHAR2, TIMESTAMP WITH TIMEZONE, BOOLEAN, PLS_INTEGER, and INTERVAL DAY TO SECOND.
  -To set an attribute to NULL, the SET_ATTRIBUTE_NULL procedure should be used.
  -What attributes can be set depends on the object being altered.
  -With the exception of the object name, all object attributes can be changed.
  - The SET_ATTRIBUTE procedure is used for altering a job
  
  -The other tasks are:
  
  -Create a job - You create one or more jobs using the CREATE_JOB or CREATE_JOBS procedures or Enterprise Manager.
  -The CREATE_JOB procedure is used to create a single job.
  -This procedure is overloaded to enable you to create different types of jobs that are based on different objects.
  -Multiple jobs can be created in a single transaction using the CREATE_JOBS procedure.
  
  -Alter a job - You alter a job using the SET_ATTRIBUTE or SET_JOB_ATTRIBUTES procedures or Enterprise Manager.
  -All jobs can be altered, and, with the exception of the job name, all job attributes can be changed.
  -If there is a running instance of the job when the change is made, it is not affected by the call.
  -The change is only seen in future runs of the job.
  
  -Run a job - There are three ways in which a job can be run:
  1. According to the job schedule — In this case, provided that the job is enabled, the job is automatically picked up by the Scheduler job coordinator and run under the control of a job slave. The job runs as the user who is the job owner.
  2. When an event occurs — Enabled event-based jobs start when a specified event is received on an event queue
  3.By calling DBMS_SCHEDULER.RUN_JOB — You can use the RUN_JOB procedure to test a job or to run it outside of its specified schedule.
  
  -Disable a job - You disable one or more jobs using the DISABLE procedure or Enterprise Manager.
  -A job can also become disabled for other reasons
  -Disabling a job means that, although the metadata of the job is there, it should not run and the job coordinator will not pick up these jobs for processing. When a job is disabled, its state in the job table is changed to disabled.

➨ Post your comment / Share knowledge