Home » RDBMS Server » Server Administration » Scheduled Jobs running twice
Scheduled Jobs running twice [message #215819] Wed, 24 January 2007 00:36 Go to next message
ShaShalini
Messages: 59
Registered: January 2007
Member
Hi Friends

I have scheduled a job to run every day at 1 AM in the morning. But I have noticed that for some days (not everyday) the jobs has run twice.

Any idea what may have caused the job to run twice.

Thanks
Shalini
Re: Scheduled Jobs running twice [message #215822 is a reply to message #215819] Wed, 24 January 2007 00:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Which method your using for scheduling " dbms_scheduler" or "OS" utility.

schedule time >>> 1 am.
and May be Possible also configure when system start or open job is run. ( in OS(Win) scheduled task ).

regards
Taj
Re: Scheduled Jobs running twice [message #215850 is a reply to message #215822] Wed, 24 January 2007 01:37 Go to previous messageGo to next message
ShaShalini
Messages: 59
Registered: January 2007
Member
Hi

I am using DBMS scheduler .. with oracle 9i and on Linux server
Re: Scheduled Jobs running twice [message #215932 is a reply to message #215850] Wed, 24 January 2007 05:56 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No you're not. DBMS_SCHEDULER doesn't exist in 9i - it's part of Oracle 10g.

So, lets try again: What are you using to schedule the job with?
Re: Scheduled Jobs running twice [message #216090 is a reply to message #215819] Wed, 24 January 2007 23:54 Go to previous message
ShaShalini
Messages: 59
Registered: January 2007
Member
I have used DBMS_JOB.Isubmit to submit the job . The view user_jobs contains a record whci shows that what program should be run and at what interval.

in My case the user_jobs contains the same date/time for NEXT_DATE and INTERVAL.

And I have noticed that for a particular date it run twice. Just wanted to know how it is possible ...

As the user_jobs contains only 1 record , it should run only once

Previous Topic: Question on setting up rules for Streams
Next Topic: alert log msg - very urgent
Goto Forum:
  


Current Time: Sat Dec 03 17:57:00 CST 2016

Total time taken to generate the page: 0.28372 seconds