jeudi 1 avril 2010

Call SRS subscription from SQL


The other an IT guy at the customer asked me if it were possible to somehow trigger an ss report creation in SQL. After some digging, here's the way I found to achieve just that:

1. Create a data driven subscription

2. Choose Scheduled, run once, set the date any time before today so it doesn’t execute

3. Find the scheduleid with:

select * from reportserver..reportschedule

4. Call subscription with:

exec msdb.dbo.sp_start_job 'YourScheduleId'


As simple as that!