OCP-1Z0-053-V13.02-216题

216.Which three elements can a job chain process involve? (Choose three)

A. an event

B. a schedule

C. a program

D. another chain

E. a lightweight job

Answer: BDE

答案解析:

参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12458


Defining Chain Steps

After creating a chain object, you define one or more chain steps. Each step can point to one of the following:

  • A Scheduler program object (program)--包含 lightweight job

  • Another chain (a nested chain)

  • An event schedule, inline event, or file watcher


    The following PL/SQL block creates a lightweight job. Lightweight jobs must reference a program, and the program type must be 'PLSQL_BLOCK' or 'STORED_PROCEDURE'. In addition, the program must be already enabled when you create the job.

    BEGIN
      DBMS_SCHEDULER.CREATE_JOB (
       job_name         =>  'my_lightweight_job1',
       program_name     =>  'polling_prog_n2',
       repeat_interval  =>  'FREQ=SECONDLY;INTERVAL=10',
       end_date         =>  '30-APR-09 04.00.00 AM Australia/Sydney',
       job_style        => 'LIGHTWEIGHT',
       comments         => 'Job that polls device n2 every 10 seconds');
    END;
    /


原文地址:https://www.cnblogs.com/hzcya1995/p/13316308.html