I am fortunate to be at Oracle Open World 14, after many years of absence. At a Birds of a feather type event 2 questions came up. Could you use EM12C for Job scheduling ? Could you use EM12c for deploying and hosting utilized database scripts ? Both great questions and i often wondered that myself.
EM12C for Job Scheduling…
I have used Cron for ever and many times I have needed that job to run and ONLY send me an email if it fails.. Sounds familiar ? A few years ago, i switched from cron jobs to Jenkins/Hudson, due to 1 job that needed to be run every day and send me an email if it fails. Well it basically didn’t run due to other factors for 14 days and caused headaches, aggravation and “Egg on the old face”. i basically had to rerun a massive job for 14 days to catch up. By switching to Jenkins/Hudson really helped that due to all the options available. Are you thinking the same thing about single point of failure ? What about H/A to solve that ? What other issues or advantages to using EM12C for job scheduling ? Please let me know
EM12C for Hosting database scripts ?
Is the better way to store database scripts and deploy them to agents/hosts ? Would Git/SVN, etc be a better choice ? We use puppet to distribute these kind of things ? What your thoughts/ideas ?
Lastly I learned about Oracles AWR Warehouse and plan to evaluate and investigate whats going on in the system. Check it out… Let me know what you think.