Re: Blat v3.1.2 not sending Subject line with multiple words in %RESULT% .

My suggestion is that you move the first quotation mark in your SET line to be immediately before the RESULT=, like this below:

Set “RESULT=Export terminated successfully without warnings”

I believe what is happening is that the quotation mark is being given to Blat within your batch file and that then causes unintended results.  If you move the quotation mark as shown above, then your batch file should not include extra quotation marks when it replaces %RESULT%.

Chip



________________________________
 From: Mathias Awundaga <[email protected]>
To: [email protected] 
Sent: Friday, May 2, 2014 9:59 AM
Subject: [blat] Blat v3.1.2 not sending Subject line with multiple words in %RESULT% .
 


 



Hello Blat Gurus,
 
I am using blat v3.1.2 on windows 2012 server for my scheduled backups. In the scripts, I use gawk to get my backup results (usually something like “Export terminated successfully without warnings” into a batch file (HOW_WAS_EXPORT.bat which will contain a line like
Set RESULT=“Export terminated successfully without warnings”
 
HOW_WAS_EXPORT.bat is then called and when %RESULT% is echoed it gives the expected results - Export terminated successfully without warnings.
Problem:
In blat v3.1.2 on Windows server 2012, an email by blat ignores %RESULT% in the subject line even though the screen output shows it. But this same line or script works well with Blat v1.9.4 on Windows server 2003.
My blat call is:
blat export_results.log -attacht %ORABACKUP%\%LOG_FILE% -i %COMPUTERNAME% -try 5 -to [email protected] -s "PEARSDEV %RESULT%  @ %END_TIME% in %COMPUTERNAME%"
 
This line sends me an email with Subject: PEARSDEV   @ 11:56:12.65  in PEARSDBTEST
 
If I change the search so that %RESULT% contains just one word, the email will contain that word.
 
God Bless you.
Thank, you 
**********************************
Mathias 
**********************************