• 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.