Home Forums SQL Server 7,2000 Replication snapshot replication job starts immediately when created RE: snapshot replication job starts immediately when created

  • If you lookup 'sp_addsubscription' in books online, you will see that there are the parameters@frequency_type, frequency_interval, @active_start_date and @active_start_time_of_day.

    These will create a schedule when to start replicating and how often.

    http://msdn.microsoft.com/en-us/library/aa239405(SQL.80).aspx

    [font="Verdana"]Markus Bohse[/font]