Re: job in cron

You might need to set ORAENV_ASK as well and run oraenv in your script.

Ronan
On 4 Aug 2015 11:45, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:

> Ok, I created a short script to run a sql job.
>
>
>
> ORACLE_SID=name;export ORACLE_SID
>
> sqlplus / as sysdba _at_sp_used > sp_used.txt
>
> uuencode sp_used.txt sp_used.txt | mail -t "oracle" myemailaddress
>
>
>
> I cronned the job. It runs fine when I execute it but in cron all I got
> was a blank attachment.
>
> When it is in cron, what userid is it using?
>
>
>
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l