December 21, 2007 at 10:47 am
Hi
I have stored procedure set as SQL job that run to gather the data from ~ 50 remote link servers, this job also compare data and just only ~ 10% of data need to be reported.
I have question about how to activate MSRS from the SQL job. The reason is this job may have to change schedule and I do not want to create schedule for MSRS due to they may loss synchronize between SQL job schedule and MSRS schedule. At the same time, I do not want to put the script in MSRS.
I also think about SSIS but it look overkill for me
Any help will be really appreciated.
Note: If this is not in this forum, please recommend me.
Thank you in advance.
🙂
December 21, 2007 at 12:18 pm
If I'm understanding you correctly, your just looking for a way to manage a SSRS subscription from another job. You can create a subscription in SSRS, disable the job it creates (represented by the GUID) in SQL Management Studio. You can then control that subscription by using an sp_start_job @Job_ID.
Tommy
Follow @sqlscribeDecember 21, 2007 at 12:40 pm
Thank, that is good idea.
😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply