I need to exclude List to whom the particular email has been sent previously from Automation Studio via SQL Activity (Data views).
select distinct s.SubscriberKey from _sent s join _job j on j.jobid = s.jobid where (j.EmailName = '@Email Name here')
Using Update operation in SQL Activity. It is giving values to my target data extension at first time.
But at next time its not working when i click on Run once.
Any Help would be much appreciated.