![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unix shell help | tipu12345 | Shell Programming and Scripting | 9 | 06-30-2007 08:26 AM |
| difference between AIX shell scripting and Unix shell scripting. | haroonec | Shell Programming and Scripting | 2 | 04-12-2006 09:12 AM |
| Difference between writing Unix Shell script and AIX Shell Scripts | haroonec | AIX | 0 | 04-12-2006 03:27 AM |
| How to run unix commands in a new shell inside a shell script? | hkapil | Shell Programming and Scripting | 2 | 01-04-2006 06:56 AM |
| How many shell available in UNIX | zp523444 | UNIX for Advanced & Expert Users | 1 | 11-13-2005 01:38 AM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
Dbms_scheduler In Unix Shell
I trying to call shell scripts through DBMS_SCHEDULER of Oracle. My procedure executed successfully and my shell scripts executed perfect in UNIX. However, the job does not run when i look through in SQL. I dont see any errors. Did any one of you use dbms_scheduler package to call shell scripts ? Do i need to add anything in my shell scripts? Please help
SQL> BEGIN 2 DBMS_SCHEDULER.CREATE_PROGRAM( 3 PROGRAM_NAME =>'CMS_DATABASE_BKUP', 4 PROGRAM_ACTION =>'/u01/j.ksh', 5 PROGRAM_TYPE => 'EXECUTABLE', 6 ENABLED => TRUE); 7 8 DBMS_SCHEDULER.CREATE_SCHEDULE( 9 SCHEDULE_NAME => 'CMS_SCHEDULE', 10 START_DATE => SYSDATE, 11 REPEAT_INTERVAL => 12 'FREQ=HOURLY; INTERVAL=1', 13 COMMENTS=>'BACKUP'); 14 15 DBMS_SCHEDULER.CREATE_JOB( 16 JOB_NAME => 'MSV_FULL', 17 JOB_TYPE => 'EXECUTABLE', 18 JOB_ACTION =>'/u01/j.ksh', 19 ENABLED => TRUE, 20 START_DATE => SYSDATE, 21 REPEAT_INTERVAL => 22 'FREQ=HOURLY; INTERVAL=1', 23 COMMENTS=>'BACKUP'); 24 END; 25 / Shell scripts- j.ksh rman target=/ <<EOF SHUTDOWN IMMEDIATE STARTUP MOUNT ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '/U01/ORADATA/%U' BACKUP DATABASE PLUS ARCHIVELOG; SQL 'ALTER DATABASE OPEN'; >> EXIT; EOF |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|