What operating system are you using?
What errors are you getting when you run the code shown in post #18?
In post #12 you say you want a backup file named EMP_FILE_bkp.txt, your code in post #18 produces a backup filename of the form emp_details.backup.YYYY-MM-DD_HH:MM.txt. Why the discrepancy in your requirements?
Why do you have a cat in your script reading from an unterminated here-document?
You need to submit crontab entries to cron's scheduler using the crontab utility. The Korn shell can't execute crontab entries!
Please explain what you are trying to do with the command: sed '/#^/G'
$FILE. The BRE in that address can't match any lines???
Why are you still using wc instead of a test -s to determine whether or not you have data to send in a mail message?
Here Again posting my requirement.
[code]
1. Have SQL query. The query should run every day between 12 pm - 3PM for every 15 minutes.
2. within thise duration it has to create backup files.
3. If the query returns any data then need to send a mail with that output file as attachment else no need to send a mail.
If would be great if I get complete script as I tried but failing in writing the script.
Thanks,
Vasu
I give up. You say you're not getting any errors! When I try running your code, I get the following diagnostic messages from ksh:
I also got errors because I don't have sqlplus install on my system, I'll assume that sqlplus also complained about the shell infinite while loop in your sqlplus script here-document, that (as bakunin suggested invokes lines that should be added to your crontab file; not executed by the ksh and not executed by sqlplus).
While it might be great for you if we would successfully guess at what you're trying to do and write your code for you, that is not our job. We are happy to help people learn how to use UNIX-, Linux-, and BSD-utilities to do the things they want to do; but the UNIX & Linux Forums is not here to act as your unpaid programming staff.
Since you're unwilling or unable to answer our questions truthfully, I don't see how I can help you. I wish you luck in your future endeavors.
This User Gave Thanks to Don Cragun For This Post:
Hi,
I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service)
lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Dear Friends,
Please help me on this
my script name is send.csh
In this i have written the statement like this
set args = ( city state country price )
I want to pass this array to another c shell called receiver.csh. and i want to use it in this c shell
or
how to pass to... (2 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Hi All,
I have new for shell scripting.
Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat.
I need to call this script at server2(my working server) and execute at server2 .
Please let me know how to build the... (5 Replies)
Hi,
I basically have 2 shell scripts.
One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system.
Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn.
... (2 Replies)
i want use ssh on the host01 to execute autoexec.sh on the host02 like following :
host01> ssh host02 autoexec.sh
autoexec.sh include nohup command like follwing :
nohup /home/jack/deletedata.sh &
after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Hi,
I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input.
I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Hi Perl/UNIX experts,
I have a problem in running a shell script from my perl script (auto.pl).
I run the perl script using
perl auto.pl
from the shell prompt
The shell script picks the files in "input" folder and procesess it.
The shell script blue.sh has this code.
export... (16 Replies)