I have a SQL Server Agent job that calls an SSIS package.
The SSIS package checks for the existence of a file in a folder.
The file may or may not exist in the folder.
The job retries a number of times before terminating.
The issue I have is that if the file does not exist , when the job finishes it writes an entry in the History Log that the “Job Failed”.
The job is scheduled to run every day, but the file will appear only once a month, and which day that happens is unknown.
So I end up with a History Log with job fail entries every day except once a month.
As far as I am concerned , the job is a success if it runs, if no file exists, that is not a failure in this context.
I am experimenting with adding an on failure precedence constraint,
The File System Task below checks for the file in a folder. If it doesn’t find the file it executes a meaningless sql query.
I thought this would solve my problem but it hasn’t as you can see from the screen grab below, it still logs a failure in the History Log.
Any guidance appreciated.