Oracle SQL Tutorial : pl sql create job in Oracle Scheduler

Показать описание

Oracle SQL Tutorial
Job In Oracle : How to Create and Run Job in Oracle Scheduler

This video will show you how to Scheduling Jobs with Oracle Scheduler.

pl sql create job

dbms job scheduler example

DBMS_SCHEDULER

----------------------

A job object (job) is a collection of metadata that describes a user-defined task that
is scheduled to run one or more times.

It is a combination of what needs to be executed (the action) and when (the schedule).

CREATE OR REPLACE PROCEDURE myproc AS
BEGIN
INSERT INTO MYTEST(CREATED_ON)
VALUES (sysdate);
commit;
END myproc;
/

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name = ‘My_job’,
job_type = ‘STORED_PROCEDURE’,
job_action = ‘MYPROC’,
start_date = ’07-AUG-16 07.00.00 PM’,
repeat_interval = ‘FREQ=SECONDLY;INTERVAL=5',
end_date =’20-NOV-18 07.00.00 PM’,
auto_drop = FALSE,
comments = ‘My new job’);
END;
/

EXEC DBMS_SCHEDULER.ENABLE(‘My_job’);

Subscribe on youtube:

For more tutorial please visit #techquerypond

oracle job scheduler