I am evaluating your Automize application and find it very helpful. I am running into a problem though. I have created a web task that downloads a particular URL every 5 minutes and logs the results. This particular URL does some backoffice administration for our site. If run successfully it reads:

Processing table AccountUsage now, please wait DONE

If it Fails, it reads something like this:

Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\backoffice\db.php on line 1121

We are trying to create a Log File Monitor that will run, after the Web task and look for the word "Warning" and then Send Email. We have currently setup the log to append the date/time so a typical file looks like: Access_Mover_web12_28_04-18_55.htm

The problem is that if we use the following variable to specify the Log File Path: $%Access_Mover_Web::LastRunEndTime%$ Access_Mover_webDec 28

Can we standardize the LastRunEndTime variable? I tried to modify the output but I get a null value. It would be very helpful if the default date/time format that was appended to the log file was the same as the default LastRunEndTime value.

Any suggestions?

Best,

Thanks for using Automize. You can try and use the $%DATE::.....%$ to specify the current time. In the filename field you could use: Access_Mover_web$%DATE::..%$ See the help file on Variables/System Variables/DATE

To make sure that you get the current time logged, you could run the the two tasks in a chain (big blue links icon on front panel)

sincerely, melvin desilva hitek software

My concern with this method is that the initial task may take longer then 1 minute to complete. Even if I chain these events together it is possible that the first one ends at minute 1 and the second one begins on minute 2. Then it would fail. Am I correct about this?

It would be really helpful if I could specify the format of the lastRunStart variable. $%LastRunStart::yy_mm_dd....%$

Thanks, Keith

Yes, if your first task takes more than 1 minute then you could get the minute off sometimes.

You can add the seconds to the filename. Here, it will not matter if it is passes a minute. In all runs the filename will be off a couple of seconds corresponding to the runtime of the second task in the chain.

regards, melvin desilva hitek software