Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_JOB (Oracle 9i)
DBMS_JOB [message #361711] Thu, 27 November 2008 12:13 Go to next message
selsee
Messages: 1
Registered: November 2008
Junior Member
Hi ,

Good Morning;

I am using Oracle9i. Using DBMS_JOB, how to set the time intervals for oly week days .
i.e It shouldn't run on week ends(Saturday,Sunday)

THanks in advance: Razz
Re: DBMS_JOB [message #361713 is a reply to message #361711] Thu, 27 November 2008 12:31 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://www.orafaq.com/node/871
Re: DBMS_JOB [message #361714 is a reply to message #361711] Thu, 27 November 2008 12:35 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/313430/102589/?msg_313430#msg_313430

Regards
Michel
Previous Topic: update issue
Next Topic: getting the closest monday date
Goto Forum:
  


Current Time: Fri Dec 09 19:36:17 CST 2016

Total time taken to generate the page: 0.16924 seconds