Hi All,

I'm just wondering if there is a way to create an alert notification on Event Triggers that will alert us that a file has not yet arrived. We currently use Event Trigger to
wait for the arrival of a Data files that are sent to us via FTP, the Event Trigger upon receipt of the file will move the file and prep it for processing.

Our dilemma is that we have no way of knowing if the file has arrived or not prior to processing without having to manually check each folder to see if there is in fact file. It would be nice to add a notification alert that would advise via email that file(s) are missing prior to processing.

Thanks
WalterH

Hi Walter,

Welcome to the forum!

Are we talking about a file on daily basis?

Regards
Erik

---

Hi Erik,

Thanks!

Yes, we have daily feeds sent to us 6 to 7 days a week.

Regards
Walter

Hi Walter,

Ok, if you are sure the file should be there at 5PM, add a time based trigger on the same job for 5PM.
The 1st task in the job should be the email task telling you the file is not there.
You have to make a condition that looks at the last run date of the file trigger. If that's one day before today, than run the task. If not continue.
The flow on the email task should be set to stop job on complete.

For the condition you could use the variable type:
Get the last run of your file trigger, looks something like this:
{TRIGGER(a770b195-114a-4f15-a445-3781b2fbe1da|21f68016-2761-497a-8b40-5f0d2e591307|LastRun|yyyyMMdd)}
You get something like: 20150429

If you substract today's date, the result will be 0 or less.

The total formula for value1 is:
{MATH(Add|Integer|{TRIGGER(a770b195-114a-4f15-a445-3781b2fbe1da|21f68016-2761-497a-8b40-5f0d2e591307|LastRun|yyyyMMdd)}|-{DATEFORMAT(yyyyMMdd)}|0)}

Type: int32, condition = smaller or equal, Value2 = -1

So if the file is not there at 5PM the email task will run, if the file came this day the condition is not met and the process of the file will happen.

Regards,
Erik

---

Hi Erik,

Thank you for you prompt response.

Interesting approach, I will add it and test it.

I will provide some feedback once fully tested.

Thanks again!!

Regards
Walter

Whilst this approach works I think it would be nice if there was an easier way to achieve this. I think it is a very common requirement.

1. With the current structure that VisualCron has now - where would you set this and how? Should this extend timeout properties on the Job as a whole or on a specific Trigger?

2. What settings would you need to be able to control what happens next? Please keep in mind that this feature needs to be very dynamic to support as many alternative actions as possible.

---

I would like the ability for an event trigger to have a time based period between which it should be active and if it hits the 'end time' then it either fires a notification or allows us to call another task or perhaps job