Home » RDBMS Server » Server Administration » Job not running on expected time (Oracle 10.2.0.3.0 HP-UX)
Job not running on expected time [message #519586] Mon, 15 August 2011 04:28 Go to next message
geobraik
Messages: 34
Registered: April 2011
Member
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.

Re: Job not running on expected time [message #519631 is a reply to message #519586] Mon, 15 August 2011 18:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Issue we are facing is job is not running on 13-Aug 11:09:00 PM
why should it?

SQL> select sysdate from dual;       

SYSDATE
-------------------
2011-08-15 16:36:40

SQL> select TRUNC(SYSDATE+1)+23.15/24 from dual;

TRUNC(SYSDATE+1)+23
-------------------
2011-08-16 23:09:00

Re: Job not running on expected time [message #519649 is a reply to message #519631] Tue, 16 August 2011 02:03 Go to previous message
geobraik
Messages: 34
Registered: April 2011
Member
Dear BlackSwan,
Thank you very much
Previous Topic: How to find the base table of a view
Next Topic: Audit Log Oracle XE
Goto Forum:
  


Current Time: Sat Apr 27 02:24:41 CDT 2024