Email Notifications when uploads fail

I developed code for PKF O'Connor Davies that alerts the uploading user when a file has failed to upload. These failures can sometimes happen without the user realizing it, so the code looks for files that get stuck in "ADDIN" status in conarc_ichannel.dbo.documents table and emails the uploading user with information about the failure.

• tFailedUploads is the table where failed upload records are stored

• FindFailedUploads can be put into a SQL job that runs regularly to find any file that has been in ADDIN status for more than 10 minutes (configurable)

• spSendFailedUploadsEmail is the stored procedure than can be put into a SQL job that runs regularly to process files put in tFailedUploads and email the users