Hi,
I have a job that runs every hour, see code below.
How do I get to run at 08:00, 12:00 and 16:00 only?
Do I have to create 3 jobs to run at 8/12, 12/24 and 16/24, or is it possible to do it all 3 in 1 job?
Thanks in advance.
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'my_check_scheduled_jobs.check_jobs;'
,next_date => to_date('26/08/2010 17:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => '/*EVERY HR ON THE HR*/ TRUNC (SYSDATE ,''HH'') +1/(24)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
I have a job that runs every hour, see code below.
How do I get to run at 08:00, 12:00 and 16:00 only?
Do I have to create 3 jobs to run at 8/12, 12/24 and 16/24, or is it possible to do it all 3 in 1 job?
Thanks in advance.
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'my_check_scheduled_jobs.check_jobs;'
,next_date => to_date('26/08/2010 17:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => '/*EVERY HR ON THE HR*/ TRUNC (SYSDATE ,''HH'') +1/(24)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/