Would a neater way be to test if the file is null or not? Does it really depend if you file has data or not? If you file does not have separate records and/or one at the end, you might still get the record count of zero, for example:-
If you just want to test for the file size being zero or not, you could try:-
This statement is to check "If $FILE exists and has a size greater than zero, then ....."
You might also want to check if the file can be read first with a similar statement, but using the -r test operator. If you need to update the file when your processing is complete, you can check if you can write to it with the -w operator. Have a look and man test for the other options.
Just my thoughts. I hope that this helps,
Robin
These 4 Users Gave Thanks to rbatte1 For This Post:
Can you guide me how to schedule the script which will run between 12 to 3:30?
I already told you in post #2: use a crontab entry. You can easily find out how to do that by reading the man page of cron and/or crontab respectively. I already told you so in post #2 too.
Could you - instead of asking repeatedly the same question - actually do what is suggested?
Your code does not match your stated requirements.
Since we do not have your environment, your databases, and still( after asking multiple times) do not even know what operating system you're using, it is difficult to correct your code when we can't see the errors you're getting.
All that we can do to help you is to ask questions that might help us help you fix your code. But, since you refuse to answer most of our questions, I have no confidence there is much we can do to help you:
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?
You can choose to answer the above questions in your next post, or we can choose to close this thread. Please help us help you by answering the questions above.
This User Gave Thanks to Don Cragun For This Post:
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.
I won't interfere with what DonCragun already does here, but this:
Quote:
Originally Posted by vasuvv
as I have lack of knowledge after googling I gave this nut am not sure how it will work. it would be great if I get from you to write the script properly.
was my suggestion. I TOLD YOU TO READ THE MAN PAGE OF cron and crontab and if you had done that (instead of googling for recipes) you perhaps would have by now understood how it works.
Sorry, but some things need a certain level of understanding before they can successfully be attempted. "Tell me how to drive a nail in" might work, even if the person never had a hammer in his hands before, but "tell me how to do open-heart surgery" will not equally work for people who are not already fully-qualified surgeons in first place. And even then it is doubtful.
UNIX is not open-heart surgery, but it is not hammer and nail either. Some things you can't just click together. You need to understand what you are doing because you need to (intelligently) make decisions while you do it and these decisions can't all be prefabricated.
So, for the umpteenth time now, execute the two (three) commands:
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)