You can create and schedule a SQL job to archive your targets.
- Create a query to retrieve the file names and their paths from the table
- Delete the files DECLARE @CMD nvarchar(max);
DECLARE @fileFullName nvarchar(128);
SET @CMD = N'xp_cmdshell ''del "' + @fileFullName + '"''';
EXEC(@CMD ); - Delete those records from the table
You can use a query or a stored procedure to do the above tasks.