Statspack 7-remove a scheduled task (resend)

To remove a scheduled task, perform the following operations:

 

SQL> select job, log_user, priv_user, last_date, next_date, interval from user_jobs;   Job log_userlast_datenext_dateinterval   -------------------------------------------------------------------------------------- 22 perfstat 2002-12-5: 14: 33: 26 2002-12-5 14:43:00 trunc (sysdate + 1/144, 'mi ')   SQL> execute dbms_job.remove ('22 ')   PL/SQL procedure successfully completed

 

When you have completed a sampling report, you should promptly remove this job. In the production environment, it is very dangerous to omit an unattended job,
If statspack runs for one week, the amount of sampled data is amazing. Some production enterprises are on the machine due to negligence!

 

From: http://www.eygle.com/statspack/statspack07.htm