I created a file in /u01/oradata directory as cronjb.ksh which contains following script

30 12 * * * /export/home/oracle/u01/oradata/rman.ksh

'/export/home/oracle' is my root directory. I then moved cronjb.ksh file to my '/export/home/oracle' directory. i typed crontab cronjb.ksh. However my cronjob named cronjb.ksh does not run. I typed mail and i dont see any email. Below is my rman.ksh script. is there any command to findout why my cronjob not working?

[B]exec>/u01/oradata/bkup_$$.log 2>&1
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
rman target=/<<
EOF
run{
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALLOCATE CHANNEL ch1 device type disk FORMAT
'/u01//oradata/ora/%U';
BACKUP AS COMPRESSED BACKUPSET
DATABASE PLUS ARCHIVELOG;
SQL 'ALTER DATABASE OPEN';}
EXIT ;
EOF[/B

What os are you using? Do you have root?

Did you get an error when you added the crontab?

what does show?


Have you checked your local email? Cron will mail any output/errors there.

It shows below

$ crontab-l
#!/bin/sh
15 12 * * * /export/home/oracle/u01/oradata/rman.ksh

yes i m top user in unix 'root'.

Please help.

Stop putting "#!/bin/sh" in your crontab files - it shouldn't be there

What he said.