June 17, 2013 at 2:01 pm
I have a SQL Server job that checks for a file in an FTP server folder. If the file is there the file is processed and the job completes. If there is nothing there (the vast majority of the time), the job fails and an error is reported. I am checking every minute from 8 am to 4 pm Monday through Friday.
What I would like to do is check if the file is in the FTP server folder, if it is there process the remainder of the 9 steps. If it is not, simply return nothing and wait until the next minute comes up. I have looked for something like count to determine if a file exists or not. I am checking for the validity of the file in the first step of the processing, but I think that there should be an easier and less error producing way to check.
I am using SQL Server 2008 R2.
June 17, 2013 at 2:42 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply