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 /

Report message to a moderator

Previous Topic: upgrade from 8 to 10
Next Topic: ASM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 15:49:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.