Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Please
Gary,
Thank you very much for the insight. I have a follow up question.
from within the unix script file, do I need to put the sqlplus user/passwd_at_db @script month spoolfile string between single or double quotes, when running from cron?
The reason I ask is I have a test script, sh format, that, when I run it from the command line it works just fine. But, when I put it into cron, it doesn't run the sqlplus line. Any thoughts?
TIA, Wolf
Gary Waldrom wrote:
> C hange the variable name to be postional variable &1 and &2 and then
> issue the script as sqlplus user/passwd_at_db @script month spoolfile
>
> the month and spoolfile parameters are substituted for &1 and &2
> respectively
>
> Gary Waldrom
> Amonra Insight Ltd.
> Authors of Q-file IT Quick Reference Guides
> http://www.q-file.com
>
>
> -----Original Message-----
> From: GreyWolf_69 [mailto:GreyWolf_69_at_alloymail.com]
> Posted At: Friday, December 17, 1999 5:16 PM
> Posted To: server
> Conversation: Help Please
> Subject: Help Please
>
> I have a sqlplus script that prompts for 2 variables. I want to run this
> script from cron on a Solaris 2.6 system. One variable is the name of
> the month, the other is a file name to spool to.
>
> I know that if I date +%b command I get only the month in return. But
> what I want is the previous month. How do I get that, then once I have
> it, how do I pass it to the sqlplus script?
>
> How would I pass that same month parameter to the file name for
> spooling?
>
> Any help would be very welcomed.
>
> Thanks a bunch,
>
> And Happy Holidays.
>
> Wolf
Received on Mon Dec 20 1999 - 10:44:16 CST