Evaluationinterval is set to NULL - Oracle DBA

Q.  After creating the chain object with CREATE_CHAIN, you define chain steps and chain rules separately. What is the correct argument which is set to NULL?
- Published on 19 Oct 15

a. Evaluation_interval
b. Define_chain_step
c. Define_chain_event
d. Schedules

ANSWER: Evaluation_interval

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -A chain is a named series of tasks that are linked together for a combined objective. Chains are the means by which you can implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.

    -The arguments are:

    -Evaluation_interval - To run the repeated eveluations we specify the evaluation_interval.
    -It is a way to make the scheduler check what to do next for moments other than job starts or at the job_step ends.
    -It is set to NULL.

    -Define_chain_step - It main task is to create steps.
    -Its privileges are Ownership of the chain, or ALTER privileges on the chain or CREATE ANY JOB.

    -Schedules - It is used to replace and extend the functionality provided by the DBMS_JOB package.
    -It is capable of handling very complicated schedules.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲