Automate reinitialization

Currently, we have many MSDE instances that subscribe to our main server.
Morning, we have to re-init whenever there's a failed subscription.
Is there a way or script to automate the reinitialization? Also, how can
we indicate it to use the current snapshot or generate a new snapshot?
Thanks in advance!
Duy
Schedule the Reinitialize subscriptions having data validation failures job.
I would create a schedule that runs twice a day.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Duy Nguyen" <tieuta@.hotmail.com> wrote in message
news:OYZgrv3tHHA.1728@.TK2MSFTNGP06.phx.gbl...
> Currently, we have many MSDE instances that subscribe to our main server.
> Morning, we have to re-init whenever there's a failed subscription.
> Is there a way or script to automate the reinitialization? Also, how can
> we indicate it to use the current snapshot or generate a new snapshot?
> Thanks in advance!
> Duy
>