Hi i created a cron entry for my id so it is the same user. Still dont know why this env variables dont get involved in the script.

Hi All

Im very new to perl scripting coming from a shell background, but im determine to stick to it and learn perl.

I have env variables which i have defined in my perl script and work fine...

Hi Salem

Tried that on Solaris 10

[date '+%m/%d/%Y':'%H:%M:%S' ; date --date='now -5 minutes' '+%m/%d/%Y':'%H:%M:%S'
09/01/2009:11:11:30
date: illegal option -- date=now -5 minutes
usage: ...

Hi

Im writing a script where im using the date command in this format.

[Datestart=`date '+%m/%d/%Y':'%H:%M:%S'`]

Is their a way to force the date variable above to go back 5minutes??

I...

Hi Salem

Thanks!! Issue resolved, appreciate the advise with the separator

[sed -e "s@DATEST@$DATESTART@g" $SQLREAD]

Output [08/26/2009:08:31:14]

Perfect for my sql file.

Hi Salem

I might of not explained it properly, what i pasted was the code and the output via set -v

The code in the script is this:
[sed -e "s/DATEST\/$DATESTART/g" $SQLREAD > $SQLNEW]
...

Hi All

Facing issue with using sed and globally replacing a word with date variable for a sql file.

Any help would be appreciated.

sed -e "s/DATEST\/$DATESTART/g" $SQLREAD > $SQLNEW

sed...

Sorry i have looked and cant find anything which would do this. If i try echoing this stop the mail attachment etc, also i dont want the message inside the subject line.

Im trying to achieve...

Hi All

Anyway to add a note inside the email saying here is your file after attching a file in unix??

For example my script is fine attaching the excel file but i would like a message inside...

Hi Mike

Well is seemed to go well then all of a sudden one day it decided to do it again :(



I think im going to cry, lol

Hi

The problem is that the file comes in already gzip, unless i could get my script to uncompress then gzip -8 filename again??

Hi All

Anyway of compressing a gzip file down evern further.

I have a file which is already compressed by gzip but is till to big to email.

Any ideas how to make it even smaller???

Hi Mike

Im going to try this for a week and see if it resolves the issue, using tar and gzip only.

Hi Mike

Here you go

Hi Mike

I tried the below but it seems to just hang etc.



Also i cant use your other suggestion as it slightly alters the columns in the data thats why ive not used gzip. Its very strange...

Should i maybe chmod 777 the file before the tar and compress part??

Hi All

Anyway of resolving this issue.

I have created a script which works properly only issue is occasionaly when the tar.Z file is emailed to me i get this message this only happens...

Ok the issue i have worked out is when there seems to be a space on the new line on the file.

i.e.

cat apps/tech/testruniquefailures
<space is here>
batchjob1
batchjob2

How do i make...

HI All

I have a script which counts how many times a job has failed.
For some reason my echo $list wont work in a variable, it works if i dont put it in a variable, but i need this in a variable...

Hi Mike

Good suggestion about the hash #

I did this and the script worked i received the email attachment, good call :)

create table tempdb..test ( A char(1))

insert into tempdb..test...

Hi Mike

I made the change to the EOF no difference.

Basically the "go" part is a sybase command to execute whatever you have queried etc

i.e. you connect to the database then put some sql...

Hey Mike

I tried just the mail part from the command line and it worked fine

cat $file | uuencode $file | /usr/bin/mailx -s "TEST" "joe.blogs@hotmail.com"

I got an email with the excel...

Hi All

Im having issues with my mail command sending data from my script.
I have a korn shell script which logs onto a database and does a few select statements.
The problem is i think the EOF...

sounds like home work, please try to attempt to write the script then we can help you out

got it skip the first 3 fields then sort numerically reverse order, cheers

excellent it work, thanks alot

so what does the sort +3nr mean??

Hi

The data is emailed to me so its all held here

cat $HOME/scripts/autoinfo1.txt | mailx -s "job failure" joeblogg@hotmail.com

that sort command doesnt work against the script, or if i pipe...

Hi Guys

I have created a script and everything works but i want my script to sort by the highest count etc.

The script counts the amount of times a job fails , for example the output looks like...

Sorry it worked, being stupid i had the $filesize variable doing the work before the data came in.
Many thanks for your help masijade. :-)

Hi

I tried that but it doesnt seem to work probably, as i had data in $filename, but it just ran echo "No Data" | mailx -s "$subject2 $day" $destination. For some reason it didnt pickup the...

Hi All

I have created a script which will email output if the file contains data, this works.
But when the file contains 0 data, it tries to email but hangs, when i hit ctrl D, it ask for Cc:...

Thanks ill have a look into them

Hi

Can anyone advise me on a good Korn Shell scripting book for me.
Im fairly new to programming, so looking for a good korn shell book.

Im considering buying two books as my work will pay...

Hi Script Masters

Im new to scripting and having trouble to get this script to work. Basically i want my script to look for files within this directory
...