Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 31st, 2009, 10:34 AM
Authorized User
 
Join Date: Sep 2008
Location: , , Singapore.
Posts: 87
Thanks: 1
Thanked 0 Times in 0 Posts
Default oracle job scheduler

I scheduled a job in Oracle 10g using DBMS_SCHEDULER on 27/03/2009 as follows:
I want to run the job every 2 days.
so Setting for the DBMS_SCHEDULER jobs:
Repeat Interval: FREQ=DAILY;INTERVAL=2
Start date : 28/03/2009 04:00:00.000
End Date : 30/03/2009 05:00:00.000
My job successfully ran on 28/03/2009@4:00 and produced the results. But It got failed when DBMS_SCHEDULER try to run(second_ on 30/03/2009 @4:00. But my enddate for the job is 30/03/2009 @5:00.
From the DBMS_SCHEDULER log table i'm able to find the reason as REASON="Next Time Eval Failed" and OPERATION = BROKEN . It means oracle DBMS_SCHEDULER tried to trigger the job but got failed.
Can anyone help me to resolve this error?




Regards
Raj
 
Old April 1st, 2009, 06:33 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Raj:

Verify how long it took for the job to actually run from start to finish. It sounds as if it took longer than 1 hour.

Just a thought.

Hope this helps.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
 
Old April 1st, 2009, 06:59 AM
Authorized User
 
Join Date: Sep 2008
Location: , , Singapore.
Posts: 87
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks.

Actually When the job successfully ran on 28/3/09 took only 2 mins to finish all my 5 chain steps.

But on 30/3/09@4:00 it not at all run atleast the Step1 of the job. That is DBMS_SCHEDULER tried to trigger the job chain @ 4:00 and got failed (information from DBMS_SCHEDULER log table says REASON="Next Time Eval Failed")
 
Old April 1st, 2009, 02:36 PM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Raj:

The conflict is between the REPEAT_INTERVAL and the END_DATE, they are the same. I recommend either changing the END_DATE outside of the REPEAT_INTERVAL or change the REPEAT_INTERVAL to 1 (once).

For clarity ... move the REPEAT_ INTERVAL between the START_DATE and END_DATE...just a suggestion.

Hope this helps.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Email Scheduler ramuis78 Pro Visual Basic 2005 1 March 13th, 2007 11:16 AM
What should i use---Job scheduler or Thread mohit_malik555 Pro Java 0 August 3rd, 2006 08:14 AM
Automatic Report Scheduler nbanaji Crystal Reports 1 September 9th, 2004 12:20 PM
submitting Oracle stored procedure or UNIX job bigraym Classic ASP Professional 0 December 22nd, 2003 02:14 PM
submitting Oracle stored procedure or UNIX job bigraym Classic ASP Basics 0 December 22nd, 2003 11:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.