Ramon,
Look in DBA_JOBS or USER_JOBS. The what and next_date columns will provide
the needed info.
Dick Goulet
____________________Reply Separator____________________
Author: "Ramon Estevez" <[EMAIL PROTECTED]>
Date: 6/29/2001 1:02 PM
Hi List,
How do I know what procedures had been submitted thru the DBMS_JOB package,
and would be
the next execution.
Ramón Estévez
*809-565-3121 x 225
* [EMAIL PROTECTED]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Blank</TITLE>
<STYLE>BODY {
COLOR: #000000; FONT-FAMILY: Arial, Helvetica; FONT-SIZE: 10pt;
MARGIN-LEFT: 25px; MARGIN-TOP: 25px
}
P.msoNormal {
COLOR: #ffffcc; FONT-FAMILY: Helvetica, "Times New Roman"; FONT-SIZE:
10pt; MARGIN-LEFT: 0px; MARGIN-TOP: 0px
}
LI.msoNormal {
COLOR: #ffffcc; FONT-FAMILY: Helvetica, "Times New Roman"; FONT-SIZE:
10pt; MARGIN-LEFT: 0px; MARGIN-TOP: 0px
}
</STYLE>
<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY background=cid:170275520@29062001-2dbb>
<DIV><SPAN class=170275520-29062001>Hi List,</SPAN></DIV>
<DIV><SPAN class=170275520-29062001></SPAN> </DIV>
<DIV><SPAN class=170275520-29062001>How do I know what procedures had been
submitted thru the DBMS_JOB package, and would be</SPAN></DIV>
<DIV><SPAN class=170275520-29062001>the next execution.</SPAN></DIV>
<DIV><SPAN class=170275520-29062001></SPAN> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV align=left
style="HEIGHT: 26px; LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px;
WIDTH: 168px">
<P align=left><FONT face=Verdana size=4>Ramón Estévez </FONT></P></DIV>
<P align=left
style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px"> <FONT
face=Wingdings size=4>(</FONT><B><FONT face=Verdana size=1>809-565-3121 x
225</FONT></B></P>
<P align=left
style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-TOP: 3px"><FONT
face=Wingdings size=4>-</FONT><B><FONT face=Verdana size=2> </FONT></B><B><FONT
face=Verdana size=1>[EMAIL PROTECTED]</FONT></B></P>
<P align=left
style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px"> </P>
<P> </P></BODY></HTML>
Blank Bkgrd.gif
Blank Bkgrd.gif