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;
    /


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值