Nested loop not running using cronjob

Login or Register for Dates, Times and to Reply

Thread Tools Search this Thread
# 8  

Thanks BD
thats the problem happening for my script. Environment variables are different for scheduler. this script i have defined for user ID 'mqsi' and crotab entery also i did for that user ID only.

now to solver this problem i added .profile file for mqsi user ID also in my script.
now some of the commands are working but some commands which are using database are giving error as ODBC return code is "-1". means it dont have acces to the database. but i am running crontab entery for the user ID 'mqsi' only then why this database access issue is occuring.

I think it will be little difficult to figure it out for u. because u dont know about my UNIX server. anyway thanks for helping it out guys
# 9  
Originally Posted by bihani4u
when i running this script directly its working fine..but only when its get executed by a croj job then only the nested for loops problem is occuring can anybody help me out..I tried everything i could but not able to find a solution
Add the following at the start of your script:
. /etc/profile
. ${HOME}/.profile

Had a similar experience on HP-UX 11.2x some time ago.
If you still have an issue, add/remove other environment files that you may use.

HTH Smilie
# 10  
Originally Posted by Cam Young
Add the following at the start of your script:
. /etc/profile
. ${HOME}/.profile

Had a similar experience on HP-UX 11.2x some time ago.
If you still have an issue, add/remove other environment files that you may use.

HTH Smilie
thanks a lot man, It worked fine Smilie
i will sleep happily today
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #46
Difficulty: Easy
Regarding computer networking, the exact meaning of the term VPN is 'virtual protected network.'
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Cronjob not running on Ubuntu 14.04

I have created a test cronjob using crontab -e that runs a script at /home/cmccabe/ I am not sure the script doesn't run though I can call it in terminal. Thank you :). crontab -e (run script sat at 6:10pm)? 10 18 * * 6 /home/cmccabe/ contents of #!/bin/bash... (5 Replies)
Discussion started by: cmccabe
5 Replies

2. Shell Programming and Scripting

My Cronjob is not running

I created a script, size=`du -sm` size=`echo $size | sed 's/.$//'` size1='30720' if then { find /ask/tarballs -type f -name "*.tgz" -mtime +30 -exec ls -l {} \; find /ask/tarballs -type f -name "*.tgz" -mtime +30 -exec rm -f {} \; } else echo "Directory size doesnt exceed Threshold... (12 Replies)
Discussion started by: shaal89
12 Replies

3. UNIX for Dummies Questions & Answers

Script not running through Cronjob

Hi, I have a .ksh script which updates the database. The script is running fine manually but it is not running through cron.All the file permissions are fine. The script contents are as below: #!/usr/bin/ksh ddate=`date +%Y%m%d` echo $ddate nohup sqlplus crm/crm @db_state_sync.sql >>... (3 Replies)
Discussion started by: shivangi
3 Replies

4. Shell Programming and Scripting

Cronjob not running

Hi, having problem running my cronjob, need the script to run every monday. And the error i'm getting is "No such file or directory", i've tried to change the env to /bin/bash and also /usr/bin/sh but both failed. Need help here. tq 0 0 * * 1 /bin/bash /home/omc/munir/ Rgds... (3 Replies)
Discussion started by: adawiyah29
3 Replies

5. UNIX for Dummies Questions & Answers

how to cancel a cronjob if the cronjob still running

hi everyone I'm newbie in this forum hope I can get some help here :) I have a command in crontab that executed every 1 minute sometime this command need more than 1 minute to finish the problem is, the crontab execute this command although it's not finish processing yet and causing the system... (7 Replies)
Discussion started by: 2j4h
7 Replies

6. UNIX for Advanced & Expert Users

SYS CRONJOB just not running...

I'm trying to run "SAR -i 60" under #/var/spool/cron/crontabs/SYS 0,10,20,30,40,50 0-6 sh -c "/usr/lib/sa/sa1 60 10 &" 55 23 * 0-6 /usr/lib/sa/sa2 -i 900 -A machine is not running above cron job under "sys" at all. This suppose to run every minutes and all time in 24 hours. When day... (6 Replies)
Discussion started by: deal732
6 Replies

7. Shell Programming and Scripting

Running scripts through cronjob.

Hello everybody, I'm trying to run a shell script in crontab file. But anyhow it's not getting executed. Following is the command that I've used in crontab. 30 07 * * * . ./.cronprofile;/om/reports/reportscripts/jitu/prod/ 35 11 * * * .... (3 Replies)
Discussion started by: jitu.jk
3 Replies

8. UNIX for Advanced & Expert Users

Cronjob is not running

hi, I have a shell script which has a sql plus code and unix if else condition. The file is located at root.I logged in as a root user and i have all permissions. I tried to set up a cron job so that the script need to run every minute.the script is running successfully without any problem. I... (2 Replies)
Discussion started by: sanei05
2 Replies

9. Shell Programming and Scripting

nested loop

I have two do loops. When I break of the inner loop it doesn't go back to the outer loop but exit the program. (5 Replies)
Discussion started by: chinog
5 Replies

Featured Tech Videos