-
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??
Environment:
HP-UX 11
Database Oracle8i R816
Thanks,
Ravi
-
Hi Ravi,
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)
for example
Jobname > outputfilename
2) use the following command to send mail
mailx -m -s "Filename" a@hotmail.com,b@hotmail.com < outputfilename
Remember to put the full path of your output filename
Let me know how it goes on.
Regards
-
Either put a .forward in ~oracle's $HOME, or explicitly main the results from your script to your intended parties.
-
Sanoth/Jeff
Thanks for the reply.I can send the mails to the specified addresses.
Thanks,
Ravi