Stored Procedures [dbo].[UpdateScheduleNextRunTime]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ScheduleIDuniqueidentifier16
@NextRunTimedatetime8
Permissions
TypeActionOwning Principal
GrantExecuteRSExecRole
SQL Script
CREATE PROCEDURE [dbo].[UpdateScheduleNextRunTime]
@ScheduleID as uniqueidentifier,
@NextRunTime as datetime
as
update Schedule set [NextRunTime] = @NextRunTime where [ScheduleID] = @ScheduleID

GO
GRANT EXECUTE ON  [dbo].[UpdateScheduleNextRunTime] TO [RSExecRole]
GO
Uses