Global Update of Email Notification List via a System table?

[NWChowd]

Hi all,

I have numerous DTS Packages which have Send Email Notification tasks in them. I would like to add someone new (namely, me!) to every Email Notification in every DTS Package that has Email Notifications without necessarily having to go into each DTS Package and add my name manually.
Can I do this via some System table or msdb table??

thanks,
DMill

======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================

 

[Patrick2002]

I don't see how, but that doesn't mean it's impossible. See if the experts on this forum can figure it out, I'm real curious too.
In the mean time : if all your DTS packages send mail to at least one common address, you could consider automatically forwarding it from that address to your own... by using a good inbox rule. It's not much work, and you get what you want. You can even pull it off if this common address is a sql server, but you'll have to take a good look at the Books on Line on the subject of treating mail by using sp_processmail and xp_sendmail.
Hope you solve your problem !