OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SQL and email

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL and email [message #165261]

Wed, 29 March 2006 02:23

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi All,
Not sure if this is the correct forum for this.

I have the following unix cron job

0 9-17 * * 1-5 /home/oracle/cron_up_down.ksh |mail email_address

This sends an email but there is no 'subject'.

Can anyone help me in being able to add a 'subject' to this email.

regards

Alan.

Report message to a moderator

Re: SQL and email [message #165273 is a reply to message #165261]

Wed, 29 March 2006 03:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

add

mail -s'subject' email address

.
The syntax may be wrong.
Check man pages for mail

Report message to a moderator

Re: SQL and email [message #165288 is a reply to message #165261]

Wed, 29 March 2006 04:44

alanm
Messages: 284
Registered: March 2005

Senior Member

Thanks Mahesh,

works great

regards

Alan.

Report message to a moderator

Re: SQL and email [message #165382 is a reply to message #165261]

Wed, 29 March 2006 13:31

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

mailx I think is another mail program, depending on your system, that I've found to be better than mail. Although on some systems there is no distinction. And yes I think -s is the subject line, there are multiple options in man pages.

Report message to a moderator

Previous Topic:	Updating record in missing physical data files
Next Topic:	Changing Time Zone in Oracle 8.1.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:33:16 CDT 2024