[dbo].[ncjobcfg_server_version]
(local)
>
mdb
>
Stored Procedures
> dbo.ncjobcfg_server_version
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@domain_id
int
4
@job_id
int
4
Permissions
Type
Action
Owning Principal
Grant
Execute
ca_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
[dbo].[ncjobcfg]
dbo