Re: Need help with DBMS_JOB

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/06/26
Message-ID: <33B2830A.6466@ebmud.com>#1/1

I believe you need a semicolon in the WHAT parameter: 'PG_JOBS.ANALYZE(0);' Frank Tropschuh wrote:

> SQL> VARIABLE ANALYZE_ID NUMBER;
> SQL> EXECUTE DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0)', SYSDATE,
> 'SYSDATE + 1');
> begin DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0)', SYSDATE,
> 'SYSDATE + 1'); end;

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect

| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com

+-----------------------------------------------------

Received on Thu Jun 26 1997 - 00:00:00 CDT