OraFAQ Forum: Server Administration » Backup at daily night 11 PM

Home » RDBMS Server » Server Administration » Backup at daily night 11 PM (oracle 9i, server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backup at daily night 11 PM [message #346065]

Fri, 05 September 2008 16:26

ramyaselvi16
Messages: 14
Registered: April 2008
Location: Chennai

Junior Member

Hi friends,

I have been granted CREATE JOB to be able to create a job. Jobs are created , but disabled by default. now I must enable them explicitly . But i need to enable automatically.

here my coding

please re change and send me solution

BEGIN

DBMS_SCHEDULER.create_job (

JOB_NAME => ‘daily_backup’,

JOB_TYPE => ‘EXECUTABLE’,

JOB_ACTION => ‘/home/n1_backup’,

START_DATE => TRUNC(SYSDATE+1)+23/24,

REPEAT_INTERVAL => ‘TRUNC(SYSDATE+1)+23/24’,

COMMENTS => ‘my back up’);

END;

Thanks

Ramya

Report message to a moderator

Re: Backup at daily night 11 PM [message #346067 is a reply to message #346065]

Fri, 05 September 2008 16:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

I am curious as to how you have DBMS_SCHEDULER available on 9i, since AFAIK it was first available with V10.

PROCEDURE CREATE_JOB
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 JOB_NAME                       VARCHAR2                IN
 SCHEDULE_NAME                  VARCHAR2                IN
 JOB_TYPE                       VARCHAR2                IN
 JOB_ACTION                     VARCHAR2                IN
 NUMBER_OF_ARGUMENTS            BINARY_INTEGER          IN     DEFAULT
 JOB_CLASS                      VARCHAR2                IN     DEFAULT
 ENABLED                        BOOLEAN                 IN     DEFAULT
 AUTO_DROP                      BOOLEAN                 IN     DEFAULT
 COMMENTS                       VARCHAR2                IN     DEFAULT

Report message to a moderator

Re: Backup at daily night 11 PM [message #346133 is a reply to message #346065]

Sat, 06 September 2008 07:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What kind of a "backup" is it?

Wouldn't you, rather (if possible), schedule it using your operating system's scheduling facility?

Report message to a moderator

Re: Backup at daily night 11 PM [message #346138 is a reply to message #346065]

Sat, 06 September 2008 07:59

malikjee
Messages: 80
Registered: May 2007
Location: lahore

Member

Please post complete detail about version plus environment.
You did not provide output form your coding as well.

please follow the guide lines of forum.

Regards,
Malik

Report message to a moderator

Previous Topic:	Data masking
Next Topic:	swap space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 22:14:10 CST 2024