I set up data driven subscription and it should send 13 emails because the criteria has been set up in the script where if the data exist then it will send an email (i.e. count(*) > 1). However when i execute the subscription it is sending random 6 emails or 7 emails. The recipient list is also different each time. I thought it couldnt send all emails because it runs very quickly so i tried to put waitfor delay of 2 seconds but it didnt make much difference.