Hi,When creating pull replication on a SQL Server 2008 Web Edition (10.0.1600.22) - it creates the pull replication properly. However, when attempting to view the job history it says: "An agent job has not been created for this subscription."There is indeed no agent job in the SQL Server Agent for the replication.However, when trying to run theexec sp_addpullsubscription_agent @publisher = N'PUBLISHER_SERVER', @publisher_db = N'TestDB', @publication = N'TestDB', @distributor = N'PUBLISHER-SERVER', @distributor_security_mode = 1, @distributor_login = N'', @distributor_password = null, @enabled_for_syncmgr = N'False', @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0, @frequency_recurrence_factor = 0, @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 20100308, @active_end_date = 99991231, @alt_snapshot_folder = N'', @working_directory = N'', @use_ftp = N'False', @job_login = null, @job_password = null, @publication_type = 0GOit says:Msg 21002, Level 11, State 1, Procedure sp_addpullsubscription_agent, Line 250The Distribution Agent for this subscription already exists (PUBLISHERSERVER-TestDB-TestDB-SUBSCRIBERSERVER-ReplTestDB-9C3FB142-47A7-455E-AB44-35FE4D2AFBB3).If it already exists, where is and how to run it?Thanks,
Are you running this on the publisher or subscriber? You should be running this on the subscriber.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Hi Hilary,Thanks for your reply. I am running it on the SUBSCRIBER box (the one that is Sql Server 2008 Web Edition).Do you by any chance have access to a Web Edition box that you can try creating a PULL subscription on and seeing if it actually creates the SQL Agent Job. For me, it creates the pull subscription, but NOT the SQL Agent Job.I am able to use the command line tool to do the synch, but this is not convenient. I would like it to create the SQL Agent Job as it should.What I am trying to figure out is this:* Is this by design a limitation of the SQL Server Web Edition* Is there a bug that prevents it from creating the SQL Agent Job for the pull agent.Hopefully, someone from Microsoft can comment as well.Thanks to all in advance!Arsen
The problem here is that Web edition doesn't support pull subscriptions, because the distributor can't be run on the subscriber with this version. The distributor must be run on the publisher, therefore only push subscriptions are supported.
- Proposed as answer by jstaal Tuesday, October 11, 2011 2:42 PM