RE: DBMS_JOB : Can submit but does not execute

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:	'ORACLE-L_at_fatcity.com'
		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: clchan_at_nie.edu.sg

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