Home » SQL & PL/SQL » SQL & PL/SQL » Job???
Job??? [message #20238] Wed, 08 May 2002 08:47 Go to next message
Fred
Messages: 34
Registered: August 1999
Member
Hi!
I have this problem; I´m trying to sumbit a job to be excuted every day at 6:23 am; but there´s the wake up agent (ot sth like that), which is set to more than 60 minutes (or so it seems), which "wakes up" and executes the jobs that are pending. Today, several days after the job submission, the "next date" has "moved" to 11:44 am.
My question is: is there a way of submitting a job with the interval parameter to be sth like 'trunc(sysdate+1) || 06:23:00'? So that the wakeup agent doesn´t "move" the expected time of execution?.
Thanks in advance!!!
Fred
Re: Job??? [message #20240 is a reply to message #20238] Wed, 08 May 2002 10:37 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://www.orafaq.net/msgboard/plsql/messages/8445.htm
Previous Topic: Bulk collect in PL/SQL
Next Topic: Oracle User Defined Functions
Goto Forum:
  


Current Time: Thu Apr 18 19:34:14 CDT 2024