Hi,
Please see the job details
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'BEGIN INVS_RIM_DATA_LOAD(''01A'',''RIMADMIN'',TRUNC(SYSDATE)); END;'
,next_date => to_date('15/08/2011 23:09:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)+23.15/24'
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
END;
/
commit;
For taking the cold backup, db is shut down on every Friday 11:00PM and open by 02:30 PM Saturday. So job expected to run on Friday night will be running by Saturday 02:30AM. It is ok for us. But problem is job is not running on Saturday night.
When checked on Sunday morning the user_jobs shows details as
User_Jobs
Last_date : 13-Aug-2011 02:30:14 AM
Next_Date : 14-Aug-2011 11:09:00 PM
Issue we are facing is job is not running on 13-Aug 11:09:00 PM
Please help me to fix this issue.