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? (1 Reply)
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... (2 Replies)
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 (1 Reply)
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... (2 Replies)
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... (3 Replies)
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... (2 Replies)
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... (9 Replies)
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... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT CENTOS
yum-cron
yum-cron(8)yum-cron(8)NAME
yum-cron - an interface to convieniently call yum from cron
SYNOPSIS
yum-cron [config-file]
DESCRIPTION
yum-cron is an alternate interface to yum that is optimised to be convenient to call from cron. It provides methods to keep repository
metadata up to date, and to check for, download, and apply updates. Rather than accepting many different command line arguments, the dif-
ferent functions of yum-cron can be accessed through config files.
config-file is used to optionally specify the path to the configuration file to use. If it is not given, the default configuration file
will be used. It is useful to be able to specify different configuration files for different use cases. For example, one configuration
file might be set to update the repository metadata, and a line could be added to the crontab to run yum-cron frequently using this file.
Then, another configuration file might be set to install updates, and yum-cron could be run from cron using this file just once each day.
FILES
/etc/yum/yum-cron.conf
/etc/yum/yum-cron-hourly.conf
SEE ALSO
yum (8)
AUTHORS
See the Authors file included with this program.
BUGS
There of course aren't any bugs, but if you find any, you should email
the mailing list, yum@lists.baseurl.org, or consult bugzilla.
Nick Jacekyum-cron(8)