The value of &start_time, &next_time should match your NLS settings so Oracle can understand and properly convert dates from strings. By default The line "dbms_job.submit( job, 'ora_monitor.db_trends.collect;', &start_time, &next_time, FALSE );" is executeuded as "dbms_job.submit( job, 'ora_monitor.db_trends.collect;', trunc(SYSDATE) + 26/24, 'SYSDATE + 1', FALSE );" If you have customized &start_time, &next_time variables, make sure they are assigned correct values Just for your reference here are the default settings in case if you changed them. Note that &next_time is a string, not a date. DEFINE start_time trunc(SYSDATE) + 26/24; -- initial start time for the DBMS_JOB dbTrends DEFINE next_time 'SYSDATE + 1'; -- time Because You need to change value of : I had a lot of problems install intalling DBTrends package. I got must done : with the exection of the data collection job scheduleing. I installed : DBMS_Jobs package but get this error when tring to run the last procedure : in the install package: DECLARE job BINARY_INTEGER; : * : ERROR at line 1: ORA-23319: parameter value "06-DEC-00" is not : appropriate : ORA-06512: at "SYS.DBMS_JOB", line 50 : ORA-06512: at "SYS.DBMS_JOB", line 120 : ORA-06512: at line 5 : here is the procedure: DECLARE job BINARY_INTEGER; : BEGIN : IF '&schedule' = 'YES' THEN : dbms_job.submit( job, 'ora_monitor.db_trends.collect;', &start_time, : &next_time, FALSE ); : END IF; : END; : Gary Mazzone : gmazzone@plansys.com
|