Stored Procedures [dbo].[ncjobcfg_server_version]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@domain_idint4
@job_idint4
Permissions
TypeActionOwning Principal
GrantExecuteca_itrm_group
SQL Script
/****** Object:  Stored Procedure dbo.ncjobcfg_server_version    Script Date: 12/1/2005 11:49:37 PM ******/


/*
************************************
*
*/


CREATE procedure ncjobcfg_server_version(@domain_id int,@job_id int)
as
begin
    update ncjobcfg set auto_server_version=auto_server_version+1
        where domainid=@domain_id
            and jobid=@job_id
end
GO
GRANT EXECUTE ON  [dbo].[ncjobcfg_server_version] TO [ca_itrm_group]
GO
Uses