Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 how to change snapshot replication schedule time ?

Author  Topic 

hdv212
Posting Yak Master

140 Posts

Posted - 2009-09-02 : 18:10:57
Hi
i've created an snapshot replication in 'On Demand' mode.
now i want to change it to continuesly and schedulable, but i don't know how to do this. can anybody help me ?
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-02 : 19:08:09
You can change the information in the SQL Agent jobs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

hdv212
Posting Yak Master

140 Posts

Posted - 2009-09-03 : 01:56:42
Thanks tkizer
i found my sql jobs for my snapshot replication. but it has no steps, whereas it do it's task as well! actually, it does not have any steps and schedule.
how can i do it ?
Go to Top of Page

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2009-09-08 : 06:18:46
sp_changepublication_snapshot
Go to Top of Page
   

- Advertisement -