Hi ,
I want to add date to the subject of the email. I am using mail and used
-s "SQL Loader was not able to load enid on `date` due to data error"
But it didnt work. can any one help me ??
Thanks
Sithara
Hi ,
I want to add date to the subject of the email. I am using mail and used
-s "SQL Loader was not able to load enid on `date` due to data error"
But it didnt work. can any one help me ??
Thanks
Sithara
I tried a simple test:
echo "SQL ... on `date` due to ..."
and got:
SQL ... on Mon Jan 3 12:51:02 EST 2011 due to ...
Can you provide additional details? More of your shell script, etc etc.
Also, I would like to suggest you use:
echo "SQL ... on `date '+%Y-%m-%d %H:%M:%S %Z'` due to ..."
because it is much easier to sort when your subject lines reads something like:
SQL ... on 2011-01-03 10:53:04 MST due to ...