USP_GLOBALCHANGE_UPDATELASTRUNON
Updates the LASTRUNON value for a given global change instance.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @LASTRUNON | datetime | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_GLOBALCHANGE_UPDATELASTRUNON
(
@ID uniqueidentifier,
@LASTRUNON datetime,
@CHANGEAGENTID uniqueidentifier
)
as
update
dbo.GLOBALCHANGE
set
LASTRUNON = @LASTRUNON,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where
ID = @ID;