FIX: Replication Error: 14262 Specified @job_id Not Found

ID: Q240290

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 54595 (SQLBUG_70)

SYMPTOMS

If you have configured replication with a pull subscription to multiple publications, you may receive the following error message if one publication becomes unsubscribed:

14262 Specified @job_id Not Found

This error occurs when the distribution agent attempts to run for the remaining publications.

CAUSE

If you unsubscribe a publication, the distribution task is removed and therefore unavailable to the remaining publications.

WORKAROUND

To work around this problem, unsubscribe all the publications for the subscriber and then resubscribe them.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: repl

Keywords : SSrvRep kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug