Re: dbms_scheduler.purge_log not working

On Dec 21, 10:08 am, "Abhijit" <abhijit_bhatt..._at_hotmail.com> wrote:
> I am facing the problem of dbms_scheduler.purge_log not purging the old
> entries from user_scheduler_job_run_details. Can anybody please help me
> out?
>
> csdm_dev_at_CSDM>select count(*) from user_scheduler_job_run_details ;
>
> COUNT(*)
> ----------
> 26438
>
> csdm_dev_at_CSDM>exec dbms_scheduler.purge_log ;
>
> PL/SQL procedure successfully completed.
>
> csdm_dev_at_CSDM>select count(*) from user_scheduler_job_run_details;
>
> COUNT(*)
> ----------
> 26438
>
> csdm_dev_at_CSDM>
>
> Also I am noticing that for the jobs that I am trying to executing , I
> am not seeing any log entries. Here is the code that I am executing. I
> will appreciate any help. The job gets executed as I can see it via
> OEM.
>
> begin
> dbms_scheduler.create_job(job_name => 'long_sleep',
> job_type => 'PLSQL_BLOCK',
> job_action => 'begin
> dbms_lock.sleep(60);
> end;',
> auto_drop => FALSE);
> dbms_scheduler.set_attribute(
> name => 'long_sleep',
> attribute => 'LOGGING_LEVEL',
> value => DBMS_SCHEDULER.LOGGING_FULL
> );
> dbms_scheduler.enable('long_sleep');
> end;
> /
>
> csdm_dev_at_CSDM>select count(*) from user_scheduler_job_run_details where
> job_name
> = 'LONG_SLEEP';
>
> COUNT(*)
> ----------
> 0

My 10g system is currently unavailable but I do not see an actual schedule or any example of your executing the job in your post. You should be able to find the last run date in dba_scheduler_jobs.

HTH -- Mark D Powell -- Received on Thu Dec 21 2006 - 10:19:47 CST