Hi,
Thanks to all who reply. After setting the job_queue_processes to 1 and
job_queue_interval = 90, the job runs successfully. Thank you.
Regds,
Catherine
-----Original Message-----
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 8:25 PM
To: [EMAIL PROTECTED]; CHAN Chor Ling Catherine (CSC)
Subject: RE: DBMS_JOB : Can submit but does not execute
Make sure job_queue_processes > 0. Also check job_queue_interval.
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 02/18/03 08:28PM >>>
Hi Gurus,
I use the following command to execute immediately.
Connected.
SQL> BEGIN
2 DBMS_JOB.RUN(1);
3 END;
4 /
PL/SQL procedure successfully completed.
--
-- I change the time for next execution to check whether it can submit
on 18 Feb 2003 at 8am
--
1 begin
2 DBMS_JOB.CHANGE(1,
3 '
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmyyyyhh24:mi:ss'),'SYSDATE+1');
4* END;
SQL> /
It did not execute. Any advice ? TIA
Regds,
Catherine
-----Original Message-----
From: CHAN Chor Ling Catherine (CSC)
Sent: Wednesday, February 19, 2003 9:15 AM
To: '[EMAIL PROTECTED]'
Subject: DBMS_JOB : Can submit but does not
execute
Hi Gurus,
I have submitted a job but it does not execute. Why?
Does the owner require any privileges ? However, I can use DBMS_JOB.CHANGE command to
execute immediately. I would like the job to execute on a daily basis. Any advice ?
TIA
--
-- Submit a job
--
1 DECLARE
2 job BINARY_INTEGER;
3 BEGIN
4
DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1');
5 DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB));
6* END;
SQL> /
1
PL/SQL procedure successfully completed.
SQL> COMMIT;
Commit complete.
--
-- Execute the job
--
1 begin
2 DBMS_JOB.CHANGE(1,
3 '
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmyyyyhh24:mi:ss'),'SYSDATE+1');
4* END;
SQL> /
PL/SQL procedure successfully completed.
SQL> COMMIT;
Commit complete.
--
-- Check whether the job is submitted
--
SQL> SELECT * FROM DBA_JOBS
JOB LOG_USER PRIV_USER
--------- ------------------------------
------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME B
------------------------------ --------- --------
--------- -------- --------- -------- ---------- -
INTERVAL
----------------------------------------------------------------------------------------------------
FAILURES
---------
WHAT
----------------------------------------------------------------------------------------------------
NLS_ENV
----------------------------------------------------------------------------------------------------
MISC_ENV
INSTANCE
---------------------------------------------------------------- ---------
1 USER1 USER1
USER1 17-FEB-03 20:01:20
18-FEB-03 08:00:00 16 N
SYSDATE+1
0
PROCEDURE_NAME;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA'
NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUME
RIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
0102000200000000
0
Regds,
Catherine
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for
the use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not the
intended recipient, you may not use, copy or disclose to anyone the message or any
information contained in the message. If you have received this communication in
error, please notify the sender and delete this e-mail message. The contents do not
represent the opinion of D&E except to the extent that it relates to their official
business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
