Hi,
I need to compare the date that a file was last written to against a threshold date. A job runs 4 times a day and if it has an issue with retrieving files, it updates a statically named error report, FrmclrHs.err. The automate workflow runs after that job to compare the last update date/time against a threshold date/time and sends an email notification if the threshold isn't met. I got the notification this morning, and when I looked at the date/time of the FrmClrHs.err report, it was last updated on 8/6, so it looks like the threshold check isn't working correctly. It worked in test (of course!). Can someone take a look at my code (attached) and see what I'm doing wrong?

I attached the .ampkg and a screen shot of the directory showing the last modified date/time of the FrmClrHs.err file.

Thanks so much for your help!
Becki

Category Survey

Hi Becki,

Step 8 appears to be missing a % at the end of the err_file_mod_time variable. This will most likely cause the If Statement to skip over its contents because it is unable to evaluate %err_file_mod_time. Please change the variable so it looks like this:

%err_file_mod_time%

Let me know if the problem persists.

Category Survey AutoMate BPA Server 8 version: Windows version:

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMIF EXPRESSION="%err_file_mod_time &gt;= %threshold_time%" AM_EMAIL="blbloch@stcharleshealthcare.org;;eanavas@stcharleshealthcare.org;;khartrich@stcharleshealthcare.org;it_automate"> SHOULD BE: <AMIF EXPRESSION="%err_file_mod_time% &gt;= %threshold_time%" AM_EMAIL="blbloch@stcharleshealthcare.org;;eanavas@stcharleshealthcare.org;;khartrich@stcharleshealthcare.org;it_automate">

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

That fixed it - thanks Leonard! It's easier to see those things in AML view, so I'll remember to do that. I would have expected Automate to throw a syntax error rather than just skip it though

thanks!

Category Survey