I am using SSMS to create a stored procedure in SQL.
Problem: I have a folder in which daily some files are getting published via the different process. The file name is in the format "Testfile datetimestamp". I want to create a stored procedure in SQL that will basically check if the file with todays date is present in the folder or not. If the file with current date is present it will trigger an email to the users that 'We have received the file' if not it will trigger email to receiver 'We are yet to receive file'.
Since I am completely new to this topic, I am not able to figure out how to start with this problem.
Any help on this would be appreciated.