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).
