I am running some SQL scripts through Crontab.When it executes those scripts a mail is sent to oracle user in Unix as I am submitting the jobs as Oracle user.I want to send the mail to some other e-mail ids.How I can do this??
Database Oracle8i R816
Iam using HP 11.x and database 8.1.6
Follow these steps
1) Send the output to a log file by using
> (Redirection output operator)
Jobname > outputfilename
2) use the following command to send mail
mailx -m -s "Filename" firstname.lastname@example.org,email@example.com < outputfilename
Remember to put the full path of your output filename
Let me know how it goes on.
Either put a .forward in ~oracle's $HOME, or explicitly main the results from your script to your intended parties.
Thanks for the reply.I can send the mails to the specified addresses.
Click Here to Expand Forum to Full Width