Search Results

I have a KSH script that runs a SQL script, then sends an email to me indicating that it's completed. I would like to modify it so that the body of the email will contain a count of the number of...

My cron job worked all weekend. Thanks guys!

It already has this line at the top, after the path:

. /usr/local/bin/TEST.env

PATH=/usr/lbin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/sbin:/bin:/usr/local/bin:$ORACLE_HOME:$ORACLE_HOME/bin:/apps:.; ...

I've got a ksh script that works like a charm when I run it manually. When I set it up in a cron, I keep getting this error in my log:

syntax error at line 90: `$' unexpected

Here's my snippet...

:D - Many thanks!!!

Oh...duh. OK, I did that...

Now, the backspace key is working : )
But the prompt is still showing my home directory regardless of where I cd to...

OK, in this statement from passwd:

user:pswd:000:00:DevLogin:/u01/app/stg:/usr/bin/ksh

the u01/app/stg is my home directory, correct? There is no .profile in that directory.

I've been doing a lot of searching through the forums to figure out how to:

1 - get my Backspace key to work in my ksh telnet session
2 - get the PWD to show up as the prompt

Solution to 1 -...

KSH - I've got a script that is generating a number of log files like this:

y=`date +"%y"`
m=`date +"%m"`

$LOG_DIR/tuscprof_tbl_$y$m.log

I only want to keep the current 2 months' worth of...

Over the weekend, my DBA pointed out to me that I should not be using that ALTER SYSTEM statement. Don't know why it was added originally, it's not my original code.

Thanks, the date/time...

I've got a SQL script that is executed through a UNIX ksh script. It is working fine, but I wanted to add a line to put a date/time stamp in the log file that it generates.

This is more of a SQL...

Aha...when I looked at man ksh for -f, it said:
-f file
TRUE, if file exists and is an ordinary file.

What does "ordinary file" mean?

But wouldn't that test to true if either:
File does not exist OR
File exists but is empty

If so, I don't think that would work for me because I want something different to happen for each of...

I've got a script with this snippet:

if [ -s $DATA_DIR/file.dat ]
then

I know that the -s indicates that the file exists and is not empty. How can I specify that the file exists, but is...

KSH...thanks for this, I will play around with it a bit, after I put out some fires.

Hmmm...there are other scripts running in cron jobs (which is where I want to put this, when it's working) that have that mailx line and are working as designed. In fact, this script works as...

Working on a script to look in a directory for a certain file. If the file is not there, check the time. If the time is greater than 10:00, send me an email. If it's not, sleep for 15 minutes and...

Thanks, I will check those out!

Ah...thank you.

Thanks...where can I find out more about the flags? I noticed bhargav used -f instead of -s...

That worked...thanks for the quick reply!!

I have a script that performs certains functions is a file exists in the specified directory:

if [ -s $DATA_DIR/test.das ]
then

How can you do the reverse of this, basically an "if file does...

Hello,

Can any of your UNIX gurus recommend a good online resource for learning UNIX scripting? I'll be doing a little bit of it, but not enough for me to feel motivated enough to go out and buy a...