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