Re: Need help with DBMS_JOB

I think you need the semicolon at the end of the execute string in the call to DBMS_JOB (I think the examples in the Oracle manual all have it).

IE:

DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0);',

                               SYSDATE,
                               'SYSDATE + 1')