Hi All, I am trying to "Create retry trigger for daily update based on Required files"

Matillion ETL
1

This job should look for required files on ftp, if it did not find the required files the job should wait and then send an email to recipients that "it is waiting for the file" and then retry to look for the required set of files.

After retrying if this job finds the files on ftp then send and email "the files are available now" if it did not find the file again then again retry trigger or fail the job.

 

Please send in your inputs on how I can achieve this as I am new to matillion.

2

You can use the Retry component on an Orchestration job to do this. The orchestration job looks for the file and if the check result is empty, then send an alert and then end the job as failure. The retry component tries if the job is failed, as many number of tries you set it for until finds a successful try. If you need additional time wait you can add a Bash component to sleep for required time. You can add alerting inside the orchestration based on the IF component.