[dbo].[UpdateScheduleNextRunTime]
(local)
>
ReportServer
>
Stored Procedures
> dbo.UpdateScheduleNextRunTime
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ScheduleID
uniqueidentifier
16
@NextRunTime
datetime
8
Permissions
Type
Action
Owning Principal
Grant
Execute
RSExecRole
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
[dbo].[Schedule]
dbo