USP_RECORDOPERATION_BUSINESSPROCESSJOBSCHEDULEDISABLE
Executes the "Business Process Job Schedule: Disable" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
Definition
Copy
create procedure dbo.USP_RECORDOPERATION_BUSINESSPROCESSJOBSCHEDULEDISABLE
(
@ID int,
@CHANGEAGENTID uniqueidentifier
)
as begin
set nocount on;
exec msdb.dbo.sp_update_schedule @schedule_id=@ID, @enabled=0;
end