I have transactional replication working pretty well. I wrote this VB utility that allows the users to manage some of the publication articles. Once again working pretty well. There is one piece I can't seem to find any help on.
After a new article is added via the utility, I want to change the schedule detail of the snapshot agent to run at 1am of the next day. If at all possible I would like to do this using the system stored procedures and not a DMO or an ActiveX object. What do ya think, is it possible?