Self-service Data Alerts in SSRS 2012 - Learning SQL Server Reporting Services 2012 - page 374

USE master
GO
DECLARE @AccountName nvarchar(260)
SET @AccountName = SUSER_SNAME(0x010500000000000515000000b243564b496c6
d2a8c486941e8030000)
DECLARE @name_in_db nvarchar(260)
select @name_in_db = sysusers.name from sysusers inner join master.
dbo.syslogins logins on logins.sid = sysusers.sid where logins.name =
@AccountName and logins.isntname = 1
if @name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @AccountName, @name_in_db OUTPUT
END
IF @name_in_db IS NOT NULL AND @name_in_db != 'dbo' AND @name_in_db !=
'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @name_in_db
END
GO
USE [ReportingService_b67933dba1f14282bdf434479cbc8f8f]
if exists (select 1 from [dbo].[sysobjects] where id = object_
id(N'[dbo].[schedule]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
declare id_cursor cursor for select scheduleId from schedule s join
msdb.dbo.sysjobs j on (convert(sysname, s.scheduleid) = j.name) open
id_cursor
declare @next_id uniqueidentifier, @account nvarchar(260)
select @account = SUSER_SNAME(0x010500000000000515000000b243564b496c
6d2a8c486941e8030000)
fetch NEXT from id_cursor INTO @next_id
while (@@fetch_status <> -1)
BEGIN
if (@@fetch_status <> -2)
BEGIN
exec msdb.dbo.sp_update_job @job_name = @next_id, @owner_login_
name=@account
END
fetch NEXT FROM id_cursor INTO @next_id
END