|
- true, but easily solved by using, for
example, TRUNC(SYSDATE+1) + 9/24
This will always be 9am tomorrow.
----- Original Message -----
Sent: Friday, October 03, 2008 2:00
PM
Subject: RE: DBMS_JOB PACKAGE - Pls Help
Me
You specify when a job should run, but it's not exact. It will run the
first possible moment after the time specified. Also it you have it set to run
every day, be careful how you set your next value. sysdate + 1 will cause a
slow creep forward in time.
Ray
From: indiatimes.com">sendakhilesh indiatimes.com
Reply-To: fatcity.com">ODTUG-SQLPLUS-Lfatcity.com
To: Multiple
recipients of list ODTUG-SQLPLUS-L
<ODTUG-SQLPLUS-Lfatcity.com>
Subject: DBMS_JOB
PACKAGE - Pls Help Me
Date: Fri, 03 Oct 2008 01:45:30
-0800
Hi,
This is Akhilesh, I am not able to execute my
scripts/procedure at exact time I mean on specific time in seconds like
(HH:MI:SS) 05:59:59 AM. I am able to execute it at 05:59 I mean not in
seconds, thru Windows Task Scheduler.
Can somebody is having a
example of scheduler thru DBMS_JOB PACKAGE ?
If yes please help and send
me the procedure step-by-step.
Thanking
You
Akhilesh
--
Will the all new Indica Vista zip
ahead of the Suzuki Swift? Read the expert review on
Zigwheels.com
http://zigwheels.com/b2cam/reviewsDetails.action?name=Ro11_20080829&path=/INDT/Reviews/Ro11_20080829&page=1&pagecount=9
--
For
more information on this topic or to become a member, visit our Web site at
http://www.ODTUG.com
Join ODTUG for The PL/SQL and The APEX Expert
Gathering of the Year! OPP2008 and APEXposed! 2008 will be held on October
29-30, 2008 at the Wyndham O'Hare, Chicago. Visit www.odtugopp.com or
www.odtugapextraining.com for more
details.
--
Author:
INET:
sendakhileshindiatimes.com
Fat City Hosting, San Diego, California
--
http://www.fatcity.com
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGurufatcity.com (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the
name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
subscribing).
-- For more information on this
topic or to become a member, visit our Web site at http://www.ODTUG.com Join
ODTUG for The PL/SQL and The APEX Expert Gathering of the Year! OPP2008 and
APEXposed! 2008 will be held on October 29-30, 2008 at the Wyndham O'Hare,
Chicago. Visit www.odtugopp.com or www.odtugapextraining.com for more details.
-- Author: Raymond De Bruyn INET: rdebruynsympatico.ca Fat City Hosting, San
Diego, California -- http://www.fatcity.com
--------------------------------------------------------------------- To
REMOVE yourself from this mailing list, send an E-Mail message to:
ListGurufatcity.com (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing
list you want to be removed from). You may also send the HELP command for
other information (like subscribing). |