Kicking off Pull Subscription Merge Agent

I am converting some code from SQL2000 to SQL2005 and I am at the part where
I start a pull subscription merge agent by looking up the merge_jobid using
the sp_helpmergepullsubscription stored procedure and then use that job id
with sp_start_job. This works fine for SQL 2000.
When I tried to do this with SQL2005, the merge_jobid comes back NULL. Is
there something wrong with my SQL2005 merge agent? If not, how can I get the
merge_jobid? If the job id is not available, is there another way to start
the merge agent from TSQL?
Thanks,
Rich
Here's the content of my MSmerge_replinfo file (on the client). I formatted
it in html to (hopefully) be easier to read.
<table border=1 cellspacing=0 cellpadding=0>
<tr>
<td width=66 valign=top s>
Repid
</td>
<td width=66 valign=top>
use_interactive_resolver
</td>
<td width=66 valign=top>
validation_level
</td>
<td width=66 valign=top>
resync_gen
</td>
<td width=66 valign=top>
login_name
</td>
<td width=66 valign=top>
hostname
</td>
<td width=66 valign=top>
merge_jobid
</td>
<td width=66 valign=top>
sync_info
</td>
</tr>
<tr>
<td width=66 valign=top>
FDB89C61-5300-4823-B78A-CA1040F03503
</td>
<td width=66 valign=top>
0
</td>
<td width=66 valign=top>
0
</td>
<td width=66 valign=top>
-1
</td>
<td width=66 valign=top>
fsadmin
</td>
<td width=66 valign=top>
NULL
</td>
<td width=66>
NULL
</td>
<td width=66 valign=top>
2
</td>
</tr>
<tr>
<td width=66 valign=top>
78597CFC-8E90-497C-B841-D9C5E34F8E84
</td>
<td width=66 valign=top>
0
</td>
<td width=66 valign=top>
0
</td>
<td width=66 valign=top>
-1
</td>
<td width=66 valign=top>
fsadmin
</td>
<td width=66 valign=top>
NULL
</td>
<td width=66 valign=top>
NULL
</td>
<td width=66 valign=top>
1
</tr>
</table>
Thanks,
Rich
"Paul Ibison" wrote:

> Richard,
> what's in MSmerge_replinfo?
> Cheers,
> Paul Ibison
>
>
|||This was on the subscriber. Looking on the publisher, I cannot find any of
the subscriber repid's on the publisher.
I have the feeling that the merge agent was not added correctly. Could you
please take a look at my sp_addmergepullsubscription_agent call and tell me
if anything is not right?
exec fsdbw.dbo.sp_addmergepullsubscription_agent @.name=N'PubName',
@.publisher=N'PubServer', @.publisher_db=N'fsdbw', @.publication=N'PubName',
@.publisher_security_mode=0,@.distributor=N'PubServe r',@.distributor_security_mode=0,@.distributor_login =N'fsadmin',@.distributor_password=N'****',@.publish er_login=N'fsadmin',@.publisher_password=N'****',@.f requency_type=2,
@.alt_snapshot_folder=N'C:\Snapshots'
The command above is used to successfully create a merge agent on SQL2000.
I noticed @.job_login and @.job_password parameters for the SQL2005 version.
Are these required? If so, could I set them to the 'NETWORK SERVICE' account?
Thanks!
"Paul Ibison" wrote:

> Presumably this is the table from the publisher (I'm hoping so!) ? Can you
> post upthe subscriber one as well. Or if this really was the subscriber one
> can you compare witht he publisher.
> Cheers,
> Paul Ibison
>
>
|||Nothing obvious at first sight, but I'd like to compare to a system-generated
one but don't have access to a server here.
Pls can you get SSMS to create and script out a pull subscription then
compare...If not then I can check tonight.
Cheers,
Paul Ibison
|||I created the subscription and generated the script. I did find some
differences, but I also found something else.
When I attempted to start the merge agent for the new subscription in
Management Studio, I didn't get the option 'View Synchronization Status' in
the right click menu of the subscription. I did some research and found that
SQL2005 Express doesn't have an SQL Agent that is needed to run the job.
Could that be my problem?
Thanks,
Rich
"Paul Ibison" wrote:

> Nothing obvious at first sight, but I'd like to compare to a system-generated
> one but don't have access to a server here.
> Pls can you get SSMS to create and script out a pull subscription then
> compare...If not then I can check tonight.
> Cheers,
> Paul Ibison
|||Also, I forgot to say -- the Subscriber is running SQL2005 Express and the
server is running SQL2005 Developer Edition.
Rich
"Paul Ibison" wrote:

> Nothing obvious at first sight, but I'd like to compare to a system-generated
> one but don't have access to a server here.
> Pls can you get SSMS to create and script out a pull subscription then
> compare...If not then I can check tonight.
> Cheers,
> Paul Ibison