Adding date to the subject using mailx

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