Home » RDBMS Server » Server Administration » Default Jobs in Oracle 10G
Default Jobs in Oracle 10G [message #220630] Wed, 21 February 2007 07:58
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I had to drop the two default jobs in oracle 10g purge logs and GATHER_STATS_JOB before appling DST Patch. Now I want them to put it back?? How do I do that??
I used following to drop

begin
2 DBMS_SCHEDULER.DROP_JOB('GATHER_STATS_JOB');
3 END;
4 /
Previous Topic: upgrade from 8 to 10
Next Topic: ASM
Goto Forum:
  


Current Time: Wed Jan 18 00:16:08 CST 2017

Total time taken to generate the page: 0.11395 seconds