Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HOURLY BASES
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07AF0.D26A5EA0
Content-Type: text/plain;
charset="iso-8859-1"
You need to set the next_date as the starting date for the job, interval as 'sysdate + (2/24)', rest of the parameters can go in as default.
Thanks,
Amar Kumar Padhi
Software Consultant
-----Original Message-----
From: Viswalingam Mohan [mailto:Viswalingam_Mohan_at_ril.com]
Sent: Wednesday, January 10, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: HOURLY BASES
Hi all
i have a function which has to be executed on an hourly basis in oracle 7.2.3
what is the larst 2 arguments in the DBMS_JOBS
MOHAN
------_=_NextPart_001_01C07AF0.D26A5EA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: HOURLY BASES</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>You need to set the next_date as the starting date =
for the job, interval as 'sysdate + (2/24)', rest of the parameters can =
go in as default.</FONT></P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Amar Kumar Padhi</FONT>
<BR><FONT SIZE=3D2>Software Consultant</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Viswalingam Mohan [<A =
HREF=3D"mailto:Viswalingam_Mohan_at_ril.com">mailto:Viswalingam_Mohan_at_ril.c=
om</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, January 10, 2001 1:50 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: HOURLY BASES</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>Hi all</FONT>
</P>
<P><FONT SIZE=3D2>i have a function which has to be executed on an =
hourly basis in oracle 7.2.3</FONT>
</P>
<P><FONT SIZE=3D2>what is the larst 2 arguments in the DBMS_JOBS</FONT>
</P>
<P><FONT SIZE=3D2>MOHAN</FONT>
Received on Wed Jan 10 2001 - 04:33:50 CST
![]() |
![]() |