Re:How to set the job's interval

From: <dgoulet_at_vicr.com>
Date: Tue, 13 Jun 2000 09:21:05 -0400
Message-Id: <10527.108908@fatcity.com>

The DBMS_JOB submit and next_date procedures require a character string t= hat it
can evaluate into a date. Therefore all of the tricks you know for conve= rting
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____________________

Subject: How to set the job's interval 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 r= un
at 15,30,45,60 minutes every hour.
Thanks in advance.

---

http://www.eachnet.com
Tel(O)=A3=BA86-21-52340871/0872*667
E-mail=A3=BAcyhu_at_eachnet.com
=A1=B0Eachnet.com - CHINA's LARGEST ON-LINE CONSUMER TRADING COMMUNITY=A1=
=B1

---

Received on Tue Jun 13 2000 - 08:21:05 CDT