Using the Database Scheduler to run ADRCI commands
Hey Folks,
Here's my challenge: I want to automate some ADR maintenance tasks using the Database Scheduler. Of course I can easily script and schedule ADRCI commands at the OS level but let's say that I have the following restrictions:
- Can't use any external OS scheduling tools or Grid Control
- Can't use any permanent OS resident objects such as scripts or SQL files
For example, maybe the command I want to execute is: adrci exec="set homepath diag/rdbms/orcl/ORCL; purge -age 60 -type TRACE"
Now yes of course I know about the automatic cleanup and the SHORTP_POLICY and LONGP_POLICY but for sake of argument say I want my scheduler job to over-ride those.
0