Q: Is it possible to trigger the email alert in Limagito after the whole scheduled run completed?
Example : run every 5 mins between 12:00:00 AM and 23:59:59PM
12:00:00 completed
12:05:00 completed
…
…
23:55:00 completed
Email will tigger
Or is there any other option to send the summary run of job every day?
A: It’s not a default option but we created a small script to achieve this. It does not matter which kind of Source or Destination you are using. So you can add this to any existing Rule.
>Open the ‘Pascal Script’ setup:
>Enable and add the following ‘On Rule Begin’ Pascal Script:
Begin
psExitCode:= 1;
// ... add your code here
psResetRTLog;
End.
>Enable and add the following ‘On Rule Begin’ Pascal Script (be sure to adjust the ctLogPath constant, we used C:\Test\Out_Log\ as temporary directory for the log files):
Var
tmpDate: String;
tmpLog: TStringList;
tmpLogFile: String;
Const
ctLogPath = 'C:\Test\Out_Log\'; // Must end with \
Begin
psExitCode:= 1;
// ... add your code here
tmpDate := FormatDateTime('yyyymmdd', Now);
tmpLogFile := ctLogPath + 'RTLog_' + tmpDate + '.log';
//
tmpLog := TStringList.Create;
Try
Try
If FileExists(tmpLogFile) Then
tmpLog.LoadFromFile(tmpLogFile);
// Add
If psLRT <> '' Then
Begin
tmpLog.Add(psLRT);
// Save
tmpLog.SaveToFile(tmpLogFile);
End;
Except
psLogWrite(1, '', 'Error Loading or Saving Log File');
End;
Finally
tmpLog.Free;
End;
End.
>The script creates a RunTime log file with the date as part of the filename (format yyyymmdd). We added C:\Test\Out_Log\ as temporary directory for the RunTime log files but you can adjust this, always end the ctLogPath constant with a backslash. Nest we’ll create a second rule which will email this file to the desired recipients.
>Now you need to add an extra rule with a WIN as Source and SMTP as Destination:
The Source path of this second rule is the path we used in the previous script. In our case this is ‘C:\Test\Out_Log\’.
>Next, please open the File Filter Setup > Advanced Tab > Enable ‘Allow parameters in File Name filter’.
>Add the following File Name Include filter: *%TCD:[IncDay-1]yyyymmdd:*
What this filter does is, it looks for a filename with a date part from yesterday because of the [IncDay-1].
So you can trigger this second rule like every 5 minutes since. When a new day starts and this second rule is triggered then it will email the log file from the previous day.
>We added SMTP as Destination since our goal was to email the RunTime log file.
>Don’t forget to enable ‘Include Source File as Attachment’ so the log file will be included in the email.
>If you set the Function to ‘Move Files’ then the log file will be deleted after successful SMTP transfer. If you want to keep the RunTime log files then set the Function to ‘Copy Files’ and enable our ‘File Memory’ option.
Result:
#FileTransfer
If you need any
info about this ‘trigger email alert after the whole scheduled run’ question, please let us know.
Best regards,
Limagito Team
