SQL Server Developer Center > SQL Server Forums > SQL Server Replication > Running SQL Server 2008 Subscription with different timings on different days
Ask a questionAsk a question
 

QuestionRunning SQL Server 2008 Subscription with different timings on different days

  • Wednesday, November 04, 2009 6:39 AMmehtar Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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

All Replies

  • Wednesday, November 04, 2009 11:23 AMHilary CotterMVP, AnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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
  • Friday, November 06, 2009 1:10 AMmehtar Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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