USP_RECORDOPERATION_BUSINESSPROCESSJOBSCHEDULEENABLE

Executes the "Business Process Job Schedule: Enable" 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_BUSINESSPROCESSJOBSCHEDULEENABLE
(
    @ID int,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    set nocount on;

    exec msdb.dbo.sp_update_schedule @schedule_id=@ID, @enabled=1;

end