| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:How to set the job's interval
But the problem for this is, if the job run @15th minute for about 5
minutes, then the next time it will start @35th minutes for another 5
minutes, then the time after that will be @55th minute etc...
If he does not mind that, then the formula will work.
I still find that the best way to make the database to run the job in a particurlar time and interval is CRON!
Winnie :)
dgoulet_at_vicr.com on 06/13/2000 07:31:25 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
Subject: Re:How to set the job's interval
The DBMS_JOB submit and next_date procedures require a character string
that it
can evaluate into a date. Therefore all of the tricks you know for
converting
data into dates works. In your case try the following:
"sysdate+(15/60)/24"
The point is to get the job to start at the correct time.
____________________Reply Separator____________________ Author: cyhu_at_eachnet.com Date: 6/12/00 6:58 PM
Hi,can anyone tell me how to set the job's interval so that the job can run
at 15,30,45,60 minutes every hour.
Thanks in advance.
http://www.eachnet.com
Tel(O)??86-21-52340871/0872*667
E-mail??cyhu_at_eachnet.com
??Eachnet.com - CHINA's LARGEST ON-LINE CONSUMER TRADING COMMUNITY??
--
Author:
INET: dgoulet_at_vicr.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). Received on Tue Jun 13 2000 - 11:48:09 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |