I use system tables to see if the table has been updated:
SELECT @expiration_dt = [modify_date]
FROM [mydb].[sys].[tables]
WHERE [name] = 'mytable'
If I detect @expiration_dt to be newer than my stored data (which obviously is datetime'd), then I rerun my code.