Which of the following are valid program types for a lightweight job?

Which of the following are valid program types for a lightweight job? (Choose all that apply.)

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Helcio

Helcio

The following example creates a set of lightweight jobs in one transaction:

DECLARE
newjob sys.job;
newjobarr sys.job_array;
BEGIN
— To create a lightweight job, the program must be enabled.
— The program action must be a PL/SQL block or stored procedure.
DBMS_SCHEDULER.ENABLE(‘PROG1’);

newjobarr := sys.job_array();
newjobarr.extend(5);
FOR i IN 1..5 LOOP
newjob := sys.job(job_name => ‘LWJOB’ || to_char(i),
job_style => ‘LIGHTWEIGHT’,
job_template => ‘PROG1’,
repeat_interval => ‘FREQ=MINUTELY;INTERVAL=3′,
start_date => systimestamp + interval ’10’ second,
enabled => TRUE
);
newjobarr(i) := newjob;
end loop;

DBMS_SCHEDULER.CREATE_JOBS(newjobarr, ‘TRANSACTIONAL’);
END;
/