Re:DBMS

From: <dgoulet_at_vicr.com>
Date: Fri, 29 Jun 2001 13:22:58 -0700
Message-ID: <F001.0033E203.20010629133109@fatcity.com>

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" <com.banilejas_at_codetel.net.do>
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

com.banilejas_at_codetel.net.do

<!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_at_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>com.banilejas_at_codetel.net.do</FONT></B></P>
<P align=left

style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px"> </P>
<P> </P></BODY></HTML>

Received on Fri Jun 29 2001 - 15:22:58 CDT

Re:DBMS_JOB