| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB
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_01C05454.EE599C10
Content-Type: text/plain;
charset="iso-8859-1"
try this
what is SP_MANUAL_REPLICATION procedure doing ...
EXEC
DBMS_JOB.ISUBMIT(1,'schemas.SP_MANUAL_REPLICATION;',SYSDATE,'SYSDATE+5/1440'
,FALSE);
COMMIT;
and see using
select JOB,LAST_DATE,LAST_SEC,THIS_DATE,THIS_SEC,NEXT_DATE, NEXT_SEC from dba_jobs
praveen
-----Original Message-----
From: Nikunj Gupta [mailto:good_dba_at_hotmail.com]
Sent: 22 November 2000 10:15
To: Multiple recipients of list ORACLE-L
Subject: Re: DBMS_JOB
Hi,
Did you try executing mannually ??
execute dbms_job.run(jobnumber);
Did it run this way ??
How many jobs have you submitted ?? What are the number of Job Queue Processess ? Is it maxed out ??
Try to submit again.. and COMMIT the job after submitting.. ie... after the END; Issue COMMIT;
HTH Nikunj
> Hi all
>
> I need to schedule a procedure using dbms_job.
>
> I created it using the following script.
>
> declare
> jobno number;
> begin
> dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', sysdate,'sysdate+1');
> commit;
> end;
>
>
> For some reason it not running at all.
>
> Any thoughts?
>
> TIA
>
> Raj
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raj Gopalan
> INET: raj.gopalan_at_netdecisions.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: good_dba_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C05454.EE599C10 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: DBMS_JOB</TITLE> </HEAD> <BODY> <BR> <P><FONT SIZE=3D2>try this </FONT> <BR><FONT SIZE=3D2>what is SP_MANUAL_REPLICATION procedure doing = ...</FONT> </P> <P><FONT SIZE=3D2>EXEC = DBMS_JOB.ISUBMIT(1,'schemas.SP_MANUAL_REPLICATION;',SYSDATE,'SYSDATE+5/1= 440',FALSE);</FONT> </P> <P><FONT SIZE=3D2>COMMIT;</FONT> </P> <P><FONT SIZE=3D2>and see using</FONT> </P> <P><FONT SIZE=3D2>select = JOB,LAST_DATE,LAST_SEC,THIS_DATE,THIS_SEC,NEXT_DATE, NEXT_SEC from = dba_jobs</FONT> </P> <P><FONT SIZE=3D2>praveen</FONT> </P> <BR> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Nikunj Gupta [<A = HREF=3D"mailto:good_dba_at_hotmail.com">mailto:good_dba_at_hotmail.com</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: 22 November 2000 10:15</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: DBMS_JOB</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi,</FONT> </P> <P><FONT SIZE=3D2>Did you try executing mannually ??</FONT> </P> <P><FONT SIZE=3D2>execute dbms_job.run(jobnumber);</FONT> </P> <P><FONT SIZE=3D2>Did it run this way ??</FONT> </P> <P><FONT SIZE=3D2>How many jobs have you submitted ?? What are the = number of Job Queue</FONT> <BR><FONT SIZE=3D2>Processess ? Is it maxed out ??</FONT> </P> <P><FONT SIZE=3D2>Try to submit again.. and COMMIT the job after = submitting.. ie... after the</FONT> <BR><FONT SIZE=3D2>END;</FONT> </P> <P><FONT SIZE=3D2>Issue COMMIT;</FONT> </P> <P><FONT SIZE=3D2>HTH</FONT> </P> <P><FONT SIZE=3D2>Nikunj</FONT> </P> <P><FONT SIZE=3D2>----- Original Message -----</FONT> <BR><FONT SIZE=3D2>To: "Multiple recipients of list ORACLE-L" = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 21, 2000 09:45 AM</FONT> </P> <BR> <P><FONT SIZE=3D2>> Hi all</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I need to schedule a procedure using = dbms_job.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I created it using the following script.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> declare</FONT> <BR><FONT SIZE=3D2>> jobno number;</FONT> <BR><FONT SIZE=3D2>> begin</FONT> <BR><FONT SIZE=3D2>> = dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', = sysdate,'sysdate+1');</FONT> <BR><FONT SIZE=3D2>> commit;</FONT> <BR><FONT SIZE=3D2>> end;</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> For some reason it not running at all.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Any thoughts?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> TIA</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Raj</FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Raj Gopalan</FONT> <BR><FONT SIZE=3D2>> INET: = raj.gopalan_at_netdecisions.co.uk</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Nikunj Gupta</FONT> <BR><FONT SIZE=3D2> INET: good_dba_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT>Received on Wed Nov 22 2000 - 01:22:11 CST
 |
 |