CREATE PROCEDURE sys.sp_MSget_subscription_dts_info
(
    @job_id varbinary(16)
)
AS
begin
    SET NOCOUNT ON
    
    -- security check
    -- only db_owner can execute this
    
    if (is_member ('db_owner') != 1)
    begin
        raiserror(14260, 16, -1)
        return (1)
    end

    select dts_package_name, dts_package_location
    from MSdistribution_agents where
    job_id = @job_id

    RETURN (0)
end