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: 25574
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: 21148
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: PFILE from SPFILE
Next Topic: Data masking
Goto Forum:
  


Current Time: Mon Aug 21 07:10:44 CDT 2017

Total time taken to generate the page: 0.05085 seconds