450th questions, 053450

450th questions, 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;/

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.