December 21, 2008 at 5:47 pm
My manager doesn't want to use the SQL Server Report Manager (2008) to schedule reports. Instead I get to write my own scheduler using Silverlight 2.0 and I need to execute reports at night and deliver them via email.
I'm a complete noob at doing this (Aside from actually writing the report and Silverlight pages). Can you tell me in detail how to run a report at night via a custom scheduler?
I was thinking the data for the schedule is to be stored in tables and at night I could run a job that would search the table and see if the day and time matches any of the schedules and if so then run the associated job and mail it to whomever the manager set it to be mailed to.
Any help is greatly appreciated.
Jon
December 21, 2008 at 8:53 pm
Hello Jon..
I think..you can opt for the Web Services which are provided by SSRS 2005 / 2008...Using the proper methods..we can acheive this...
Thanks,
Niraj
December 22, 2008 at 11:17 am
Ok, then can someone recommend a good book on how to do this? I can't seem to find one for 2008 on Amazon.
December 22, 2008 at 11:54 am
What's the reason behind your manager not wanting to use the builtin Report Manager?
It's easy to start with at least
December 22, 2008 at 11:59 am
Jerry Hung (12/22/2008)
What's the reason behind your manager not wanting to use the builtin Report Manager?It's easy to start with at least
Oh man don't get me started on the absurdity of it. It doesn't send the user an email when a report fails. Also, he wants me to recreate this UI and the UI of job processing in one page so users can schedule jobs because the dba is, well, to put it politely an idiot.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply