Home » RDBMS Server » Server Administration » Backup at daily night 11 PM (oracle 9i, server 2003)
Backup at daily night 11 PM [message #346065] Fri, 05 September 2008 16:26 Go to next message
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
Re: Backup at daily night 11 PM [message #346067 is a reply to message #346065] Fri, 05 September 2008 16:47 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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
Re: Backup at daily night 11 PM [message #346133 is a reply to message #346065] Sat, 06 September 2008 07:36 Go to previous messageGo to next message
Littlefoot
Messages: 20896
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?
Re: Backup at daily night 11 PM [message #346138 is a reply to message #346065] Sat, 06 September 2008 07:59 Go to previous message
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
Previous Topic: Data masking
Next Topic: swap space
Goto Forum:
  


Current Time: Tue Dec 06 12:31:06 CST 2016

Total time taken to generate the page: 0.16150 seconds