053第450題，053450

053第450題，053450

450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A. PLSQL_BLOCK
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL
Answer: AD

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

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。