Running SQL Server 2008 Subscription with different timings on different days

Question

Hi,

We are trying to create two subscriptions from one publishers, each one to run at different times on different days.

Is it possible to do?? and How.

Thanks and best regards,
Rajnish

Answer 1

If you have two separate subscriptions you will need to modify the schedules for the different days.

An Agent can have multiple schedules configured for it.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

Hi Hilary,

We are using Oracle Publisher to create publisher on our SQL Server (to get data from our Oracle Datawarehouse by transactional replication). The SQL Server acts both as an Distributor and Subscriber for replication data.

The issue we are facing is that when we unable to create two subscriptions from same publishing as we cannot have different names for the two subscriptions which originate from the same publisher using the create subscription wizard. may be there is a way to create second subscrption using T-SQL procedures??

Thanks and best regards,
Rajnish