Re: Opinion on change control for DBA scripts

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 28 Jun 2013 12:12:56 -0500
Message-ID: <CAJvnOJa+XtxmzSoRScWrtX4+9vyMSugnzJ71k9y9xXUX2kY_Qg_at_mail.gmail.com>



We have had a lot of luck with this:
http://sourceforge.net/projects/jobscheduler/

Setup can take time, but we have had a lot of luck with it, and its free. unijob is also pretty good.

<SNIPT>

>
> My expansion to this topic is about job scheduling. For those who need to
> support hundreds of database servers, what do you use to schedule
> maintenance and monitoring jobs across them all? We have many jobs in EM
> but have also inherited systems with jobs run out of cntrl-m (which is a
> pain because we don't have access to the tool). In either case preferred
> credentials have to be maintained (which is also "fun" on all these systems
> with password expiration rules) and setting up proper checks and balances.
> For the latter I'm referring to issues with schedulers. It's making sure
> that what you expected to run actually did run, that key jobs didn't
> somehow disappear, that agents didn't suddenly crash and no one noticed,
> etc.<SNIP
> <SNIP>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 28 2013 - 19:12:56 CEST

Original text of this message