running sql in crontab Post: 26675

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers running sql in crontab Post 26675 by dorilevy on Thursday 22nd of August 2002 06:14:33 AM

08-22-2002

Registered User

the script -

Code:

#!/bin/csh 
set c_str = "rating_info/rating@bscsprod"
set file=`ls -lrt /var/tmp/Rep4* | tail -1 | awk '{print$9}'`
set workfile="/tmp/Rep4.txt"
set temp="'"
set ttt="\.\." 
cat $file | sed 's/'$temp'/./g' > /tmp/a.txt
cat /tmp/a.txt | sed 's/'$ttt'/-/g' > /tmp/b.txt
cat /tmp/b.txt | sed 's/'\,'/\  /g' > $workfile
rm /tmp/a.txt
rm /tmp/b.txt
foreach stam ("00-04" "04-08" "08-12" "12-16" "16-20" "20-24" "> 25" )
 cat $workfile | grep "$stam" | cut -f2-6 > /tmp/sss.txt
 set s_str=""
 foreach num ( `more /tmp/sss.txt` )
   if ( `echo $num | cut -c1 ` == "." ) then
    set s_num="0$num"
   else
    set s_num="$num"
   endif
   set s_str="$s_str $s_num"
 end
 sqlplus $c_str @/bill/app01/bscsprod/scripts/dori/update_delay.sql `echo $s_str` "'$stam'"
 rm /tmp/sss.txt
end
set delay=`cat $workfile | grep "Delay" | cut -f2`
sqlplus $c_str @/bill/app01/bscsprod/scripts/dori/update_unpr.sql "$delay" 'delay'
set udate=`head -1 $workfile`
sqlplus $c_str @/bill/app01/bscsprod/scripts/dori/update_time.sql "'$udate'" 'update'

added code tags for readability --oombera

Last edited by oombera; 02-18-2004 at 06:45 PM..

dorilevy

View Public Profile for dorilevy

Find all posts by dorilevy

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SQL vs Crontab

I've been trying to execute a script which call some SQL Queries for midnight report, using crontab I got the next mesage: Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus If I use the "at" command it...

2. UNIX for Dummies Questions & Answers

running .sh, .sql .etc how to?

hi all yes, I am a beginner in Unix,-sun solorais--V8... what is the command to run files.... single and batch jobs....any help would be great... Cheers ps...i know running files in Sqlplus on Unix prompt, I can use the @' sign...but how does this work.. Cheers E

3. Shell Programming and Scripting

crontab and shell script that executes a sql.

Problem: I have a crontab and when it kicks off, xxx.sh shell script is called. Which has a nohup sqlplus session call. Problem is sql does not get executed and a text file is not getting created. Only a empty log file is getting created. Are there any constraints for crontab to open a sql...

4. Shell Programming and Scripting

Access SQL with crontab

Hi, I wrote a script shell whose function is to make a remove of directories depending on the result of a query on Oracle database. When I execute my script shell directly from unix, it works fine. But, when I put it in a line of a crontab, it doesn't work no more, because of the sql...

5. UNIX for Advanced & Expert Users

Crontab is not running!!!

Hi experts, need your helpo. after editing the crontab while saving the file it says- "/tmp/crontabRlaauT" 1 line, 77 characters cron may not be running - call your system administrator And i checked after certain time. script in cron is not running. I got a mail in user saying...

6. UNIX for Dummies Questions & Answers

Issue while running from crontab

Hi All, Here is my command which I've scheduled to be run from crontab, but it's giving error message: rah: rahhost executable needed but not in PATH My cmd is- 36 10 * * * /opt/IBM/dwe/db2/V9.5/bin/rah "df -m" >> /db2home/bculinux/Files/log/db.out 2>&1 Though I've added path...

7. UNIX for Dummies Questions & Answers

Crontab + Script + .sql

Hi guys today i'll bring to you a new problem that i need to execute. So what i need to do it's create a script that: conect to some database logon run a .sql script logoff and close the connection after that, put this script on the crontab To set up the crontab it's ok for me, i think...

8. UNIX for Dummies Questions & Answers

crontab not running script

Hi All, I am having the below script to be run from crontab, it it doesnt run. 1 * * * * /home/cobr_ext/test.sh > /home/cobr_ext/temp.txt when i run i manally it runs without any issues. Could please help me as to why doesnt it run the script.:(

9. Solaris

Crontab is not loading/running

hi, i have crontab where i have put my db backup scripts but crontab do not run at specific time. i have checkted the scripts andwhen run the script as ./mydbbkp.sh so it successfully run and do the job but from cron it is not running whihcmeans cron is not running. i have an oracle user under...

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

LEARN ABOUT REDHAT

cron

CRON(8) 						      System Manager's Manual							   CRON(8)

NAME

       cron - daemon to execute scheduled commands (Vixie Cron)

SYNOPSIS

       cron

DESCRIPTION

       Cron should be started from /etc/rc or /etc/rc.local.  It will return immediately, so you don't need to start it with '&'.

       Cron searches /var/spool/cron for crontab files which are named after accounts in /etc/passwd; crontabs found are loaded into memory.  Cron
       also searches for /etc/crontab and the files in the /etc/cron.d/ directory, which are in a different format (see  crontab(5)).	Cron  then
       wakes up every minute, examining all stored crontabs, checking each command to see if it should be run in the current minute.  When execut-
       ing commands, any output is mailed to the owner of the crontab (or to the user named in the MAILTO environment variable in the crontab,	if
       such exists).

       Additionally,  cron checks each minute to see if its spool directory's modtime (or the modtime on /etc/crontab) has changed, and if it has,
       cron will then examine the modtime on all crontabs and reload those which have changed.	Thus cron need not be restarted whenever a crontab
       file is modified.  Note that the Crontab(1) command updates the modtime of the spool directory whenever it changes a crontab.

SEE ALSO

       crontab(1), crontab(5)

AUTHOR

       Paul Vixie <paul@vix.com>

4th Berkeley Distribution					 20 December 1993							   CRON(8)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SQL vs Crontab

Discussion started by: alex blanco

2. UNIX for Dummies Questions & Answers

running .sh, .sql .etc how to?

Discussion started by: etravels

3. Shell Programming and Scripting

crontab and shell script that executes a sql.

Discussion started by: radhika

4. Shell Programming and Scripting

Access SQL with crontab

Discussion started by: tbeghain