sql server replication: It seems every time a snapshot is made the next scheduled run is
disabled and listed as "unknown" on the status tab of the agent
properties. Once I go back into the schedule properties and re-enable,
it runs that night but then goes back to unknown the next day. Any
ideas? I've seen similar posts but no answers.

thanks

SQL version: 2000
Rep type: Snapshot

How was this subscription/publication created? IIRC some subscriptions
created by ActiveX scripts have agent properties disabled.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Hi,
It was created via Enterprise Mgr using the standard Create Publication
Wizard (no scripts)

thanks,
George

In enterprise manager,
select the agent that performs the snapshot, select properties,
schedule, edit, make sure it is recurring, then select change, make
sure the duration has no end date.


[quoted text, click to view]