OK OK so I missed the semicolon after the 'statspack.snap' command . . . sorry.
problem fixed - back to normal state. -bill > -----Original Message----- > From: Magaliff, Bill > Sent: Friday, December 13, 2002 11:55 AM > To: Oracle-L (E-mail) > Subject: DBMS_JOB problem > > 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).