Home » Infrastructure » Unix » cron job (10g, AIX 6.0)
cron job [message #578217] Mon, 25 February 2013 14:14 Go to next message
Messages: 16
Registered: November 2011
Location: Indianapolis
Junior Member

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 Go to previous messageGo to next message
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:


[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 Go to previous message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
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.

Previous Topic: OS Solaris Parameter That May Affect the SGA
Next Topic: Unix Script to load data into the Oracle server from Oracle client
Goto Forum:

Current Time: Thu Dec 02 05:57:50 CST 2021