RE: DBMS_JOB PACKAGE - Pls Help Me

Thread: RE: DBMS_JOB PACKAGE - Pls Help Me

Search this list only Search all lists
RE: DBMS_JOB PACKAGE - Pls Help Me
	2008-10-03 08:00:39

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:  sendakhileshindiatimes.com Reply-To:  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).

[1]

about | contact Other archives ( Real Estate discussion Medical topics )