Re: RMAN job scheduling 10g

graff3_at_hotmail.com wrote:
> 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:

>> graff3_at_hotmail.com wrote:
>>> 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
>> Retraction as I hadn't noted that you have 10g.
>>
>> Use the DBMS_SCHEDULER built-in package.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

Don't Top Post

Not going to happen.

What's the business case that makes RMAN not work as desired?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org