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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
