Re: DBMS_JOB problem

Bill,

Try putting a ';' after snap that may fix it.

SQL> variable x number;
SQL> begin
 2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24');  3 end;
 4 /

> I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on
> Metalink, I've try to run the following:
>
> SQL> variable x number;
> SQL> begin
> 2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24');
> 3 end;
> 4 /
> begin
> *
> ERROR at line 1:
> ORA-06550: line 1, column 108:
> PLS-00103: Encountered the symbol "END" when expecting one of the following:
> := . ( @ % ;
> The symbol ";" was substituted for "END" to continue.
> ORA-06512: at "SYS.DBMS_JOB", line 79
> ORA-06512: at "SYS.DBMS_JOB", line 131
> ORA-06512: at line 2
>
> Any ideas on this error? No helpful info on Metalink.
>
> Checked the status of the package, too:
>
> 1* select object_type, status from all_objects where object_name =
> 'DBMS_JOB'
> SQL> /
>
> OBJECT_TYPE STATUS
> ------------------ -------
> PACKAGE VALID
> SYNONYM VALID
>
> Thanks
>
> bill
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Magaliff, Bill
> INET: Bill.Magaliff_at_lendware.com
>
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: JRicard982_at_aol.com

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