subscription is sending dupe emails/dupe sql agent job(s)
Posted on 2006-11-10
I made a modification to one of my reports recently (sql/rs v2K, vs .net 2003)
i just added 3 more subscriptions to it...so, it is to run 4 times daily, issuing an email each time.
it just now ran today's run #1, and it sent two emails....so, i go in there and i find 4 new sql agent jobs.
so, now there's eight jobs for the 4 subscriptions. obviously, i only want/need four. i've blown the extras out,
but, why would this happen? i'm concerned about today's next 3 runs.