11-13-2009
Crontab problem!
Hi All,
i added a sh script to crontab, it run but there is sqlplus expression that generate a spool file(gun.lst). this expression didnt run.
Summary,
1- my main script is topl.sh that i added it to Cron via "crontab -e" command
2- There is "sqlplus username/password@serverA @umt.sql" expression in topl.sh
3-umt.sql exists:
SET heading OFF
SET termout off
SET underline OFF
col offline_directory format a50
SET pagesize 0
SET verify OFF
SET echo off
SET linesize 50
SET feedback off
spool gun
select t.deger from tts.parametre t where t.id=30
;
spool off
exit;
4- All commands,expressions which are in topl.sh run, but "sqlplus username/password@serverA @umt.sql" expression didnt run so topl.sh script didnt generate gun.lst spool file.
by the way, when i run topl.sh manuel(without Cron), it is successfully.everything is ok.
i dont know why gun.lst spool file wasnt generated, when i add it on Cron.
Not: i added it to cron like that:
00 9 * * * /....../topl.sh
Thanx.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I trying to include a script in my crontab as user. I used "crontab -e" to include my script there but does not seem to work. If I understand correctly it is set to run at 11:20 every day, correct?
Can anybody identify any error?
<pre>
#Sun Microsystems Inc. SunOS 5.7 Generic... (19 Replies)
Discussion started by: guest100
19 Replies
2. Shell Programming and Scripting
HI,
i am working on linux.
i have crontab problem
i wrote a small script and put it in a crontab .
but the script is not running..
i have given following way in crontab -e
02 06 * * * /bin/csh /home/vr_test.csh
but the above script is not running
please rectify my... (26 Replies)
Discussion started by: rajan_ka1
26 Replies
3. UNIX for Dummies Questions & Answers
I'm trying to get crontab to run a script, but to test crontab I tried out a very simple command: `echo bob`
here is my crontab file (I edited it by using `crontab -e`):
-----------------
#!/bin/sh
23 10 * * * echo bob
and at 10:23 every day I get a new message:
in /var/mail/a... (3 Replies)
Discussion started by: cleansing_flame
3 Replies
4. UNIX for Dummies Questions & Answers
i added to my crontab file:
* * * * * echo "hello"
it works, i receive a message into my /var/mail/username
and i receive: bob
in addition to a large text add-on
any help appreciated (1 Reply)
Discussion started by: cleansing_flame
1 Replies
5. UNIX for Advanced & Expert Users
hi all
while using crontab -e im receiving
754 as output
im unable to add a entry in crontab
crontab -l is working fine
OS: sun5.8
can some one please assist me (4 Replies)
Discussion started by: NIMISH AGARWAL
4 Replies
6. Shell Programming and Scripting
Dear All ,
I have .sh script wich has the following inside
getFileName=Listportfolio.txt.`date +'%Y%m%d`
ftp -n 172.10.10.1<<EOF
user xxx xxx
bin
cd /home/gbs/FTP_Script
get /home/gbs/FTP_Script/$getFileName
bye
EOF
EOF
when I run the... (3 Replies)
Discussion started by: habuzahra
3 Replies
7. Shell Programming and Scripting
Hi All,
Am facing an issue while updating the crontab.Getting below error while updating the cron.
cron/tmp.XXXX5fXBR6: No space left on device
crontab: edits left in /tmp/crontab.XXXXEJX5gw
Is there any file where i need to alter using root user so that i can update the cron.
TIA... (9 Replies)
Discussion started by: Ashok_oct22
9 Replies
8. AIX
Hi to all.
Guys, i have a truble with oracle user crontab.
He work if i'm do
0-59 * * * * echo LOL> ~/test.txt
But not work if me set realy norm date
For example
14 17 28 12 * echo LOL> ~/test.txt
In 17:14 28 December .
In log file /var/adm/cron/log nothing....
Please... (3 Replies)
Discussion started by: jess_t03
3 Replies
9. UNIX for Advanced & Expert Users
hi..
i have a program (tf.sh), and i want what it runs automatically with a "lapsus" of 2 hours. (1,3,5,7,9,11,13,15,17,19,21,23 hrs.)
i know what i have to do it using crontab, but i donīt know how to do it.
i have the next idea, but the problem is what it doesnīt run on my server... (11 Replies)
Discussion started by: DebianJ
11 Replies
10. Solaris
hi all
does any on has explanation for this result
bash-3.00$ crontab -e
"/var/tmp/Ex1kayUW" No space left on device
The crontab file was not changed.
bash-3.00$ (2 Replies)
Discussion started by: osmannix
2 Replies
LEARN ABOUT DEBIAN
kep_reload
KEP_RELOAD(1) General Commands Manual KEP_RELOAD(1)
NAME
kep_reload - Update Predict's Keplerian elements
SYNOPSIS
kep_reload
DESCRIPTION
KEP_RELOAD is a simple utility that forces an immediate reload of PREDICT's Keplerian database through a socket connection while PREDICT is
running in server mode. It is especially useful in environments where PREDICT runs continuously, and periodic Keplerian element updates
are made outside of PREDICT, such as through scripts run through a crontab.
The "kepupdate" script found in this directory is an example of a Keplerian element update script that can be run on an automated basis
through a crontab. It is designed to be placed in your home directory under a subdirectory called "cronjobs". It downloads Keplerian
orbital data from www.celestrak.com using the HTTP protocol. (The "wget" utility, available from the Free Software Foundation, is
required, and is included in many Linux distrubutions.)
Type crontab -e to edit your crontab. Simply add the following entry:
0 8 * * * kepupdate
and your orbital database will update each morning at 8:00 AM (provided you have a network connection at that time).
See the crontab man page for more information on editing your crontab.
AUTHOR
This man page was written by A. Maitland Bottoms, AA4HS, for Debian GNU/Linux.
31 August 2003 KEP_RELOAD(1)