var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cron isnt working well
Im having abit of trouble here..
I have a .sql and also .sh file in my unix system. It is supposed to update two tables in my oracle database.
When i run the .sh file, it does the work properly without problem but when I cron it, it does but the row is not reflected in my database.
Ive checked on the paths, commit and so on.. but have no idea why this is happening only when i cron it.
INSERT into PREPAID_IN_UNSPECIFIED_CALL VALUE(
SELECT to_date(COD_DATE, 'yyyymmdd'), NBR_CALLS, TOT_COST, TOT_DURATION
SELECT COD_DATE, TOTAL_CALLS, TOTAL_COST, TOTAL_DURATION from PREPAID_IN_UNSPECIFIED_CALL);
sqlplus username/password@IT_RA @/app/ITRAKPI/Unspecified_Call/insert_unspecified.sql
more /app/ITRAKPI/Unspecified_Call/insert_unspecified.log | mailx -s "Unspecified_Call_Insertion" firstname.lastname@example.org
03 11 * * * /app/ITRAKPI/Unspecified_Call/insert_unspecified.sh
Anyone can analyze this and inform me whats the problem ? Im sure nothing is wrong with the codes since it can run when i do it manually. ??
Cron does not execute your profile. You’ll have to include the profile settings (for path, etc.) in your script.
thx a lot bro..
i just added this into my .sh file
and there it GOES !!!
thx thx !
another question that I have.
I am trying to put a cc in the mailx code, anyone knows
I tried this way but it isnt working
more /app/ITRAKPI/Unspecified_Call/insert_unspecified.log | mailx -s "Unspecified_Call_Insertion" email@example.com -c firstname.lastname@example.org
if possible i want the topic to look like this Updation_Of_Unspecified_Call for 21/09/2005(which is todays date)
eventhough its not that important but i want to know how.
Back qoutes around date command and -c moved
pdreyer, this is what it exactly says
mailx: illegal option -- c
usage: mailx [-FUm] [-s subject] [-r address] [-h number] address ...
mailx [-UHLiNn] [-u user]
mailx -f [-UHLiNn] [filename]
any idea ?
Nope, beets me, I'm using mailx version 5.0 on Sun Solaris
mailx [ -BdFintUv~ ] [ -b bcc ] [ -c cc ] [ -h number ]
[ -r address ] [ -s subject ] recipient ...
im using HP-UX Server, and am not sure why the -c isnt working but then i would do it this way..
more /app/ITRAKPI/Unspecified_Call/insert_unspecified.log | mailx -s "Updation_Of_Unspecified_Call for `date '+%d/%m/%Y'`" email@example.com firstname.lastname@example.org
It works as well..
Thanks anyway.. U solved one of my biggest problem..