I ran an Alert to update 168 records and then ran a query in the Advanced Report Studio to see if the data was updated correctly. There appeared to be a delay of 8 minutes from when the Alert began to when the database record was actually updated. This is the method used by the vendor whom deployed the software and one I have also used to make other data corrections. I've not noticed this with the previous alerts. Can you help me understand why there is a delay and how long I should wait before checking data?
The alert Before SQL is attached.