Search Results

You're right, I had to edit it to keep it confidential (although, no one could really do anything by just knowing the dir and script name I guess...).

Other than <directory> and <scriptname>,...

It seems permission related to me (think someone else said it could be that above).

I'm not at my work PC atm, but the output of crontab -l is...

35 14 *** /directory/<scriptname>

Cheers for the feedback. I'm working on something else at the moment (hurrah for priorities), but I'll come back to this ASAP, sometime tomorrow.

Thanks again.

---------- Post updated 05-13-11...

I can run my script at command line with no problems, is that what you mean?

I use VMWare with Solaris, seems to work OK

Hi

I'm trying to set up a crontab on AIX and for some reason it's not running my script at the specified time - here's what I have tried so far:



30 14 * * * <scriptname>
35 14 ***...

Hi

I added the above to my script, however it didn't do anything (i.e. no ERRORS within my new log file, however there are errors in update.logs).

The script doesn't error, just hangs at...

Hi,

I have a log file (updates.log), and I want to hunt the file for any errors. Here's an example of the log file:

SQL> update <table1> set <value1> = '*****';
update <table1> set <value1>...

Resolved, cheers everyone

@Corona688 - I created a new script, the content is:

#!/bin/sh

ORACLE_HOME=/apps/oracle/10.2.0.4
export ORACLE_HOME

sqlplus u/p@sid <<selectupdate
spool selectupdateX.txt
@<script>.sql;...

Okay thanks for the feedback. I'm off now but will be picking this up first thing tomorrow morning.

Looking forward to nailing this... !! :)

@ Peasant - Tried that, although it gives the same result as some of my previous attempts. A file is produced and the content is:

SQL> @scrambler_SELECT_UPDATE_V0.4.sql
93 EOF
94 ...

Good point, I didn't think of that.................

I don't understand why it's gerating that error; I don't believe that I'm ever setting "selectupdate" as a file or directory.

Thanks for the suggestion. Here's an update of my code:
sqlplus user/password@SID <<selectupdate > selectupdate.txt
set heading off
spool selectupdateX.txt
@<select_script>.sql;...

Hi,

(Oracle, AIX)

I have googled this and searched this forum, however I haven't had much luck with an answer and have tried several different things.

Basically I have a SQL select...