Visit Our UNIX and Linux User Community


Cron job running problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cron job running problem
# 1  
Old 05-29-2010
Cron job running problem

Hi Guys,

I am trying to run a script through contab. The script can only be executed once user logs in as su - oracle. I have tested the script other then cronjob and it executes successfully, more over the paths used in the script are absolute paths.

Crontab entries are as as below.
Code:
15,30,45,59 * * * * su -oracle -c /var/opt/log/my.sh


Shell is as below, Shell interacts with the Oracle DB and extracts the required data.

Code:
root@ServerA[/var/opt/log]# cat /var/opt/log/db_analy.sh
#!/usr/bin/bash

sqlplus my_usr/my_passwd@ServerA @/var/opt/log/db.sql

Code:
root@ServerA[/var/opt/log]# cat db.sql
set HEA OFF
set heads off
set pagesize 0
SPOOL /var/opt/log/db_analyze.log
SELECT Count(*) From T1 WHERE $state = 'O'; 
SPOOL OFF
exit

If I execute this /var/opt/log/db_analy.sh --- it is executed sucessfully but there is no output wen i added it in conjob.

Any sugesstion will be appriciated.
Thx in advance,
BR//Asteroid
# 2  
Old 05-29-2010
Failing cron jobs almost always have problems with environment variables, i.e., ORACLE_HOME, TWO_TASK....

to debug your problem:
Code:
15,30,45,59 * * * * su -oracle -c /var/opt/log/my.sh 2&>1 > /tmp/my.log

edit your script and add this at the top, right under #!/usr/bin/bash
Code:
set

# 3  
Old 05-29-2010
Which OS is it? Is it the crontab entry of root user? How do you exactly call that script when you run it manually?
This is a plain guess, but maybe there should be a whitespace between the minus sign and oracle Smilie
# 4  
Old 05-30-2010
Thx guys, The problem has been resolved by setting environment variables.

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

CRON job still running?

Hi All, I am writing a script that will eventually be executed by a cron job every 15 minutes. I want to make sure that my logic/script doesn't get executed if a previous job is still running. What would be the best way to handle that scenario? I was thinking to make my script create a temporary... (1 Reply)
Discussion started by: rdogadin
1 Replies

2. Solaris

Cron job running even after cron is removed

Hi , I have removed a cron for particular user , but cron job seems to be running even after the cron entry is removed. The purpose of the cron was to sendmail to user ( it uses mailx utility ) I have restarted cron and sendmail service still user is getting mail alerts from the cron job. And... (4 Replies)
Discussion started by: chidori
4 Replies

3. Solaris

Cron job is not running

Hi, I have set up the crontab as follows. root@IDC4VASAPP07 # crontab -l 0-59 * * * * /var/tmp/r.sh 0-59 * * * * date >> /var/tmp/log root@IDC4VASAPP07 # r.sh is as follows. root@IDC4VASAPP07 # cat r.sh #!/bin/bash dt1=$(perl -e 'use POSIX;print strftime... (10 Replies)
Discussion started by: SunilB2011
10 Replies

4. Shell Programming and Scripting

cron job and running program

Dear experts, I have this cronjob * */2 * * * $path/supervisor.sh The supervisor script is checking another script, which initializes the final scripts in multiple directories. Note that the supervisor script runs without the cronjob. In each directory, I have the following script: ... (2 Replies)
Discussion started by: TheTransporter
2 Replies

5. UNIX for Dummies Questions & Answers

Problem running a cron job

I have created a cron job for the vtiger workflow to execute the shell file named com_vtiger_workflow.sh to run the workflow. I've created the following line in crotab -e : 00 13 * * * /var/www/html/prashant/cron/modules/com_vtiger_workflow/com_vtiger_tiger_workflow.sh | mail -s 'Check... (2 Replies)
Discussion started by: anaigini45
2 Replies

6. UNIX for Dummies Questions & Answers

Cron job not running

Hi All, I am editing crontab using -e option to add a new job Below is the line 30 * * * * scriptpath This job is not executing every thirty minutes. I have checked, cron daemon is running. What did I miss? Can some one help? I am using cron shell..ksh (7 Replies)
Discussion started by: yabhi_22
7 Replies

7. UNIX for Dummies Questions & Answers

cron job not running to completion

am running a cron job to do a backup of all user files. the script runs properly in the terminal but only backups about 20% of the files when run by cron. the Linux system is running BASH as far as I can tell. the symbols $FILE and $DIRECTORY are defined properly and the following is the... (1 Reply)
Discussion started by: novice633
1 Replies

8. UNIX for Advanced & Expert Users

cron job is not running

hi, i have the following line in the crontab 15 5 * * 6 /home/adw/BCE_ADW.pl The problem is the cron job is not getting started automatically. But this was working til last week. now it is not working. what could be the problem. Any idea? (3 Replies)
Discussion started by: Suguna
3 Replies

9. Shell Programming and Scripting

Cron job entry not running

Hi, I am facing this problem . My Cronjob entry is not running !!! I am having Sun solaris 9 and cronjob entry is "45 1 * * * /safedir/rdns/opt/RDNS1.1Scripts/drpl_audit_log_script.sh_orig > /dev/null 2>&1" Now when I try to look in the output log files it creates, it is some file with... (1 Reply)
Discussion started by: hkapil
1 Replies

10. HP-UX

Cron Job Not Running

Hi, I have a cron schedule like this 04,16,28,40,52 * * * * /nag/startProcessABatch (unix script) i want to add new lines in this file (like Logging), i just copy this file into a /tmp folder (for backup copy), and i have edited this file (added few lines of code for logging). ... (1 Reply)
Discussion started by: nag_sundaram
1 Replies

Featured Tech Videos