I've got a scenario where I'd like to validate if a table has been modified in the last 5 minutes, and if it has, run a SQL report and save the results to an Excel file on the network. There isn't a whole lot of activity in this table throughout the day, but it is overwritten each time it is changed, so I want to capture a snapshot at the time it is changed. There is a linked table that has a timestamp for when the table in question was updated, so that will be my condition.
My question is more geared to how to save the results of a SQL report to an Excel file on a schedule. Thanks.
Please sign in to leave a comment.