Is there such an animal as 'SFTP Folder event that fires when a file is created?'
Posted on 2016-10-19
(Warning: SQL Server expert, everything else related to this question N00b.)
I've been tasked with finding out if a SFTP folder (CrushFTP) can have an event that fires when a file has been added to it, and if that event can execute a SQL Server Agent job or any custom script?
For some reason the client is opposed to a SQL Agent job firing every 10 minutes to detect if the file exists, and if it does not then to exit the job.