OraFAQ Forum: Unix

Home » Infrastructure » Unix » cron job (10g, AIX 6.0)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: cron job [message #578218 is a reply to message #578217]

Mon, 25 February 2013 14:19

BlackSwan
Messages: 20230
Registered: January 2009

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: 54650
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.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 00:51:29 CDT 2013

Total time taken to generate the page: 0.17729 seconds