We have SQL 2000 Merge replication with 2 publications...one with tables and
the other with views and sp. The Snapshot Agent for the tables publication
is bad (shows red X and status = Failed). If I try to start the agent it
gives me Error 14262 indicating the @job_id ('....') does not exist.

Can anyone tell me if I need to re-create this snapshot? Or can I just
delete the publication and re-create it using the sql script file I saved?
I am not sure how this will affect laptop users. Will they get the new
snapshot when they synch next time? Thanks for any help on this.

David

David - can you refresh the jobs folder and then find the snapshot agent and
run it manually then tell us what happened.
Also, refresh the replication monitor using sp_MSLoad_replication_status .
Also, did you create this setup using scripts edited manually?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .