Re: DBMS_JOB : Can submit but does not execute

Have you set the "job_queue_processes" parameter in you init.ora file?

CHAN Chor Ling Catherine (CSC) wrote:
> 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

-- 
  Ing. Michal Zaschke
    DB Administrator
Sokolovska uhelna, a.s.
tel.: +420 352 465417
e-mail: zaschke_at_suas.cz

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michal Zaschke
  INET: zaschke_at_suas.cz

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