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