Scheduling OEM jobs
Currently in our place, all db jobs are scheduled through cron. We want to move them to a centralized OEM. There are 2 ways you can schedule a job through OEM.
1. Call a script remotely on the db server that does the job (eg analyze the schema) by running an os command
2. Perform the operation directly from OEM (select db as a target and select analyze as the operation)
Which is better?
I am thinking #1 because
1. We have control on what we are running
2. Wont be a burden on the OEM box (eg if 5 backup jobs kick off at the same time, which is highly likely as there are around 10-12 production databases)
What is your practical opinion on this?
Click Here to Expand Forum to Full Width