Scheduling SSRS reports using an external scheduling package

We use a scheduling package to coordinate the scheduling of our batch
processes on most of our systems. Is there a way to trigger the
running of an SSRS report this way? And, what the specifics of what
is takes with some examples of how and what needs to be interfaced?
Thanks,On Sep 17, 12:49 pm, thill...@.steelcase.com wrote:
> We use a scheduling package to coordinate the scheduling of our batch
> processes on most of our systems. Is there a way to trigger the
> running of an SSRS report this way? And, what the specifics of what
> is takes with some examples of how and what needs to be interfaced?
> Thanks,
You can look into the rs.exe utility. Also, you might want to consider
calling a URL similar to this one to obtain the physical report file
and then attach it to an email. You can do this in ASP.NET (attaching
the file to an email, streaming the report file directly from an
HTTPRequest of the URL below), etc. It's up to you're preference and
expertise.
http://ServerX/reportserver?/Directory/ReportName&rs:Command=Render&Param1=Param1Value&rs:Format=PDF
Format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

scheduled job control

i'd like to use external vbscript task to check [running] status of
scheduled jobs on sql database, to see is particular job running,
and may it be forced to start or stop.
do i need some special component or is all allready bilt in into sql server?
thanks for comments.Look at sp_help_job in Books Online. It should give you everything you
need.
"sali" <gabor.salai@.tel.net.ba> wrote in message
news:#g43N6AKFHA.1052@.TK2MSFTNGP10.phx.gbl...
> i'd like to use external vbscript task to check [running] status of
> scheduled jobs on sql database, to see is particular job running,
> and may it be forced to start or stop.
> do i need some special component or is all allready bilt in into sql
server?
> thanks for comments.
>
>