OraFAQ Forum: Server Administration » Scheduled Jobs running twice

Home » RDBMS Server » Server Administration » Scheduled Jobs running twice

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scheduled Jobs running twice [message #215819]

Wed, 24 January 2007 00:36

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

Report message to a moderator

Re: Scheduled Jobs running twice [message #215822 is a reply to message #215819]

Wed, 24 January 2007 00:44

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

Report message to a moderator

Re: Scheduled Jobs running twice [message #215850 is a reply to message #215822]

Wed, 24 January 2007 01:37

ShaShalini
Messages: 59
Registered: January 2007

Member

Hi

I am using DBMS scheduler .. with oracle 9i and on Linux server

Report message to a moderator

Re: Scheduled Jobs running twice [message #215932 is a reply to message #215850]

Wed, 24 January 2007 05:56

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?

Report message to a moderator

Re: Scheduled Jobs running twice [message #216090 is a reply to message #215819]

Wed, 24 January 2007 23:54

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:38:04 CDT 2024