My Digital Life in Data Flow

If you can link to your Reporting server you can setup a local Stored procedure and then from the server you can execute that

but you need to
setup a email subscription on the report
then find the report name from this Query
WITH SQlJobs (job_id, job_name, execution_time, execution_order)
AS
(
SELECT DISTINCT j.job_id
,j.name
,CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':'))
,ROW_NUMBER() OVER (PARTITION BY j.job_id ORDER BY CONVERT(datetime, STUFF(STUFF(run_date,7,0,'/'),5,0,'/')
+ SPACE(1)
+ STUFF(STUFF(RIGHT('000000' + CONVERT(varchar(20), run_time), 6),5,0,':'),3,0,':')) DESC)
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.syscategories c ON j.category_id = c.category_id
LEFT OUTER JOIN msdb.dbo.sysjobhistory jh ON j.job_id = jh.job_id
WHERE c.name ='Report Server'
)
SELECT

x.job_name [SQl Agent Job]
,c.name [Source Report Name]
--,x.execution_time [Last Executed]
--,c.path [Report Path]
--,su.description [Description]
,'exec ReportServer.dbo.AddEvent @EventType=''TimedSubscription'' , @EventData='' '+ Convert(varchar(500),su.SubscriptionID) + '''' [Source SQLStatement ]
FROM SQlJobs x
INNER JOIN dbo.Schedule sc ON x.job_name = CONVERT(varchar(100), sc.ScheduleID)
INNER JOIN dbo.ReportSchedule rs ON sc.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Subscriptions su ON rs.SubscriptionID = su.SubscriptionID
INNER JOIN dbo.Catalog c ON su.Report_OID = c.ItemID
WHERE execution_order = 1


the source sql statement looks something like this

exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='XXX-XXX-XXX-XXX'


the @eventData is the ID from the dbo.subscriptions table

that table has a field called Parameters that looks like this

'<ParameterValues><ParameterValue><Name>Value</Name><Value>You can automate Reports </Value></ParameterValue></ParameterValues>'

it is NText field


in an Sp you can do the following

supply a text based value
then update the subscriptions table parameters report to be like this



declare @value varchar(30)

set @value='You can automate Reports ' --Subsitute a value in here

select @value
update Subscriptions
set Parameters=

'<ParameterValues><ParameterValue><Name>Value</Name><Value>' + @value + '</Value></ParameterValue></ParameterValues>'
where SubscriptionID='XXX-XXX-XXX-XXX'


then
refire the job in the SP

exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='XXX-XXX-XXX-XXX'


so the Job would be something liek this



declare @value varchar(30)

set @value='You can automate Reports ' --Subsitute a value in here

select @value
update Subscriptions
set Parameters=

'<ParameterValues><ParameterValue><Name>Value</Name><Value>' + @value + '</Value></ParameterValue></ParameterValues>'
where SubscriptionID='XXX-XXX-XXX-XXX'


exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='XXX-XXX-XXX-XXX'