| cron job [message #578217] |
Mon, 25 February 2013 14:14  |
 |
OracleDBA2010
Messages: 16
Registered: November 2011
Location: Indianapolis
|
Junior Member |
|
|
Hello,
I would like to schdule a select query in cron tab to run every day at 11:45PM. Can some one help?
I created a file like this and its not working.
export oracle_sid=test123
export oracle_home=/oracle/product/10g
sqlplus / as sysdba
select * from dual;
And schduled this test123.sql file in cron like this.
45 11 * * * test123.sql
|
|
|
|
| Re: cron job [message #578218 is a reply to message #578217] |
Mon, 25 February 2013 14:19  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
do you realize & understand this question & answer have NOTHING to do with Oracle?
do you realize & understand that *NIX environmental variables are CaseSenSive?
"oracle_sid" is different from "ORACLE_SID"
Besides PATH is not correctly established
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
[Updated on: Mon, 25 February 2013 14:20] Report message to a moderator |
|
|
|
| Re: cron job [message #578219 is a reply to message #578217] |
Mon, 25 February 2013 14:19 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
There are many examples in the Unix forum.
Please search for and read these topics.
And do NOT multipost your questions, above all in the wrong forum.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
