May 30, 2008 at 2:03 pm
Can I use sp_changesubstatus @publication ='pubname', @status = 'inactive ', @publisher = 'Oracle Pub DB' to pause replication from an Oracle Publisher while work is done on the Oracle database?
And then use sp_changesubstatus @publication ='pubname', @status = 'active ', @publisher = 'Oracle Pub DB' to restart replication once the work is complete?
Thanks in advance for you help ...
May 30, 2008 at 4:58 pm
You can stop the replication agent too...
MohammedU
Microsoft SQL Server MVP
May 30, 2008 at 5:24 pm
Thanks Mohammed, at the risk of sounding dumb, is that just the job(s). I dont have access to my work SSMS right now.
May 30, 2008 at 5:27 pm
No, you see the replication agents in replication monitor...
These monitors execute the jobs...so you can stop and disable the job too...and you need to reenable and restart the job...after your work is done...
MohammedU
Microsoft SQL Server MVP
May 30, 2008 at 6:28 pm
Excellent, thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply