053 Question No. 450

450.Which of the following is valid program types for a lightweight job? (Choose all, 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 is 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 seconds '); end;/

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

053 Question No. 450