create procedure sys.sp_stoppullsubscription_agent
(
@publisher sysname,
@publisher_db sysname,
@publication sysname
)
as
begin
set nocount on
declare @retcode int
,@stop tinyint
set @retcode = 0
set @stop = 1
-- Security check
exec @retcode = sys.sp_MSreplcheck_subscribe
if @@error <> 0 or @retcode <> 0
return 1
exec @retcode = sys.sp_MSpullsubscriptionagentjobcontrol
@publisher = @publisher,
@publisher_db = @publisher_db,
@publication = @publication,
@action = @stop
return @retcode
end