Disappearing distribution job

  • I am copying all data from a production database to a development counterpart (both SQL Server 7) weekly by means of snapshot replication, but I am mystified by the repeated disappearance of the distribution job.  I use the Enterprise Manager wizard to create the push subscription on Friday, creating a distribution job in the SQL Server Agent list, the job runs on schedule early Saturday morning, and sometime between Tuesday and Wednesday the job disappears from the list.  (Note: The associated snapshot job has remained in the SQL Server Agent list since I created it via the Enterprise Manager wizard three or four weeks ago.)  When the wizard creates the job I review its properties to confirm that it has no end date; but, even if it had one, I would expect the job to be disabled after that date, rather than deleted.  I would be grateful for any suggestions regarding the cause of this problem and how to prevent it.

  • Have a look at the subscription expiration on the general tab of the publication properties.  It may be that the subscription is expiring after a certain time and is getting dropped 

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply