Job call package execution of how to set up in the morning do a do a night

CodePudding user response:

This a few methods:

1. The two job set different time;
2. In the store, make a logical judgment, if the time is not 6 a.m. and 9 PM, do not perform logic code;
3. If the two time interval is 12 hours, can put the next _date is set to + 1/2

CodePudding user response:

Or to create an afternoon two job one morning
Or in the job do judgment (=what)
Assuming the job performs a judgment time per minute for '08:00' or '8' is a process to perform
Declare
V_time=to_char (sysdate, 'hh24: mi);
The begin
If v_time='08:00 or v_time=' 8 'then
Sp_job;
end if;
end;

CodePudding user response:

Determine the current time to perform, or set a time interval, and then to perform on time

CodePudding user response:

Suggestions in the process control, to prevent the JOB unexpected problems, cause behind the time is right