RMAN job scheduling 10g

graff3@hotmail.com · *nix forums beginner Joined: 20 Dec 2005 Posts: 21

Hi guys,

I have noticed when a RMAN job is scheduled using OEM it is given
special status to other Oracle jobs.

I want to know how can one schedule a RMAN job using SQL Plus or RMAN
so the our jobs can be displayed in the OEM's RMAN view.

Cheers

Max

psoug · *nix forums Guru Joined: 15 May 2005 Posts: 3492

graff3@hotmail.com wrote:

psoug · *nix forums Guru Joined: 15 May 2005 Posts: 3492

graff3@hotmail.com wrote:

graff3@hotmail.com · *nix forums beginner Joined: 20 Dec 2005 Posts: 21

Hi Daniel,

You are right about the DBMS_SCHEDULER package. But that is what I am
currently using and NOT entirely satisfied -

I want my following SQL to be treated by RMAN as its own job rather
than a generic Oracle job.

BEGIN
sys.dbms_scheduler.create_job(
job_name => '"SYS"."TEST"',
job_type => 'EXECUTABLE',
job_action => 'c:\test.bat',
start_date => sysdate,
job_class => 'DEFAULT_JOB_CLASS',
comments => 'hello',
auto_drop => FALSE,
enabled => FALSE);
sys.dbms_scheduler.set_attribute( name => '"SYS"."TEST"', attribute =>
'restartable', value => TRUE);
sys.dbms_scheduler.enable( '"SYS"."TEST"' );
END;

Cheers

Max

DA Morgan wrote:

psoug · *nix forums Guru Joined: 15 May 2005 Posts: 3492

graff3@hotmail.com wrote:

graff3@hotmail.com · *nix forums beginner Joined: 20 Dec 2005 Posts: 21

My business case is as follows -

1. I want my job to be recognized as an RMAN job. If you use OEM to
create an RMAN job you will notice that RMAN jobs are treated
differently.

2. I do not want my job to be displayed in the Oracle job queue like
other jobs.
3. I want to send a RMAN query directly rather than embedding it into a
batch file and calling it as an executable.

sybrandb · *nix forums beginner Joined: 13 Jul 2006 Posts: 22

graff3@hotmail.com wrote:

graff3@hotmail.com · *nix forums beginner Joined: 20 Dec 2005 Posts: 21

Sybrand...if you can't add value to a conversation..you should shut the
F#$K up.

sybrandb wrote:

Google