Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HOURLY BASES

RE: HOURLY BASES

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Wed, 10 Jan 2001 14:33:50 +0400
Message-Id: <10737.126244@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US