Script (with sql queries) not working using cron Post: 302716049

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear?

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Hi there folks, I am trying to execute remote sql queries on an Oracle server. I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address. Could anyone give me an idea on how the above could be achieved? Any help...

3. UNIX for Dummies Questions & Answers

shell script for sql queries

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you

4. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect...

5. Shell Programming and Scripting

Script is not working from cron while working manually

Hello, I am facing a very strange problem when I run my script manuallu ./Fetchcode which is using to connect with MKS integrity from linux end it workks fine but when I run it from cron it doesn't work.Can someone help me 1) How could I check my script when it is running from cron like...

6. Shell Programming and Scripting

Script not working in cron but working fine manually

Help. My script is working fine when executed manually but the cron seems not to catch up the command when registered. The script is as follow: #!/bin/sh for file in file_1.txt file_2.txt file_3.txt do awk '{ print "0" }' $file > tmp.tmp mv tmp.tmp $file done And the cron...

7. Shell Programming and Scripting

Executing set of sql queries from shell script

Hi All, I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below sqlplus user/pwd@dbname << EOF > output.log $(<inputfile.txt) EOF The above code is capturing the output of queries into...

8. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required.

9. Shell Programming and Scripting

run sql queries from UNIX shell script.

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused:

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 OSF1

atrm

atrm(1) 						      General Commands Manual							   atrm(1)

NAME

       atrm - Removes jobs spooled by at

SYNOPSIS

       atrm [-a] [-f  | -i] [job_number...] | [user...]

       The atrm command removes jobs that were created with the at command.

OPTIONS

       Removes	all  jobs  belonging to the person invoking atrm.  If invoked by a privileged user, all jobs on the queue are removed.	Suppresses
       the printing of all information about the jobs being removed.  Prompts before a job is removed; a response of y, or the locale's equivalent
       of y, causes the job to be removed.  Obsolete version of -a.

DESCRIPTION

       If one or more job numbers is specified, atrm attempts to remove only those jobs.

       If  one	or  more  usernames is specified, all jobs belonging to those users are removed.  This form of invoking atrm is useful only if you
       have superuser authority.

EXAMPLES

       To remove job number 62169200.a, created by user chinn, from the queue created by the at command, enter: atrm chinn.62169200.a

       Note that specifies an at job for sh.  (.f specifies an at job for csh, and specifies an at job for ksh.)

FILES

       Main cron directory.  List of allowed users.  List of denied users.  Spool area.  Queue description file for at, batch, and cron.

SEE ALSO

       Commands:  at(1), atq(1), cron(8)

       Files:  queuedefs(4)

																	   atrm(1)