Re: disable all RMAN jobs in Grid Contol

From: NetComrade <netcomrade_at_gmail.com>
Date: Thu, 29 Apr 2010 13:32:31 -0700 (PDT)
Message-ID: <4150377c-148e-4933-b56f-85e9e181817e_at_y36g2000yqm.googlegroups.com>

On Apr 28, 7:30 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Apr 28, 1:39 pm, NetComrade <netcomr..._at_gmail.com> wrote:

> > We do all oracle related jobs through grid control, including custom
> > monitoring scripts, that way we don't have to hunt down outputs from
> > cron.

...
> > With 20-30 databases to track all over the place, cron is really not a
> > good option. Plus, how is modifying cron on 2-3 dozen hosts easier
> > then clicking through a few jobs in a single interface?
>
> Well obviously, in the situation you have here, you can write a spider
> script to modify everything everywhere a lot easier with shells,
> assuming one could have tight control over the crons.  It's common
> (er, ought to be common) in cron based backups to have a marker file
> tested to see if the backup should run, just like it is common in unix
> startup scripts for everything in the rc's.
>
> I don't know anything about grid, but I have seen with dbconsole the
> same problem ashttp://technology.amis.nl/blog/2892/how-to-stop-running-rman-jobs-in-...
> which kind of suggests to me there might be something about
> mgmt_job_engine that could handle your issue.  Searching for that on
> MOS finds some interesting things, maybe a support call would be
> worthwhile, even if just to give a wishlist item.  

This was actually very helpful.. Thanks Joel. What is MOS?
And I avoid calling support like plague.. usually wasted time. The quality of support dropped significantly, no-one calls you back, no-one bothers to read SR notes, and worst thing, are no-one is actually knowledgeable on the subject they're supposed to be experts in.

DECLARE
BEGIN
FOR jguid IN
--modify this query for whatever jobs you want to suspend, e.g. job_name like 'RMAN_%', or job_name like 'RMAN_GROUP%' (SELECT job_id
FROM mgmt_job
WHERE job_name like 'RMAN_%'
AND job_owner = 'SYSMAN'
AND parent_job_id is null
AND is_library=0)
LOOP
BEGIN

--mgmt_job_engine.suspend_job(jguid.job_id);
--mgmt_job_engine.resume_job (jguid.job_id);
--dbms_output.put_line(jguid.job_id);

END;
END LOOP;
END; Received on Thu Apr 29 2010 - 15:32:31 CDT