When running jobs which are dependent on external sources (dropping of a file in an ftp folder), it may be necessary to run a multiple times till the file is found and the job run for that day.
One way to do this is to insert a row into a log table which will hold the job start date and time and the job end date and time. This table can be checked to see if the job has already been run for the day, if not the job can be run, else exit quietly.
Add a database input component to check if a row exists for the day:
Then add a ‘Run If’ condition before the next step: