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

Hi ,
I created a batch only to transfer the files from local server to share
folder on another server. I put the batch in the DTS package and scheduled it.
When I trace the job , the file have been copied but the "Status" of the
job still stick on "Executing Step 1 ..." and it no turn to success although
the file had been copied. What's wrong with that actually ?
Thanks ,
Travis
--
Travis TanHi ,
why u are making ur work complex .
U can transfer the files using file tranfer protocol task in DTC
package.
When the batch finishes tanfer sqlserver doesnt come to know the status
and it shows executing status.
from
Doller
Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success although
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
> --
> Travis Tan|||Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success although
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
>
Are you looking at the status in Enterprise Manager? In that case you
might need to refresh it to see the actual status.
Regards
Steen|||Hi Doller ,
Thanks for your info and I understand what you said. The actually process
in DTS was
1) Transfer The Files
2) UnZip The Files
3) Restore the transaction logs
Because the Transfer Files pending in "executing" so no Unzip process is
done. Means that no way for me to resolve that ?
Thanks ,
Travis
Travis Tan
"doller" wrote:
> Hi ,
> why u are making ur work complex .
> U can transfer the files using file tranfer protocol task in DTC
> package.
> When the batch finishes tanfer sqlserver doesnt come to know the status
> and it shows executing status.
> from
> Doller
>
> Travis wrote:
> > Hi ,
> >
> > I created a batch only to transfer the files from local server to share
> > folder on another server. I put the batch in the DTS package and scheduled it.
> >
> > When I trace the job , the file have been copied but the "Status" of the
> > job still stick on "Executing Step 1 ..." and it no turn to success although
> > the file had been copied. What's wrong with that actually ?
> >
> > Thanks ,
> > Travis
> >
> > --
> > Travis Tan
>

Scheduled Job

Hi ,
I created a batch only to transfer the files from local server to share
folder on another server. I put the batch in the DTS package and scheduled i
t.
When I trace the job , the file have been copied but the "Status" of the
job still stick on "Executing Step 1 ..." and it no turn to success althoug
h
the file had been copied. What's wrong with that actually ?
Thanks ,
Travis
Travis TanHi ,
why u are making ur work complex .
U can transfer the files using file tranfer protocol task in DTC
package.
When the batch finishes tanfer sqlserver doesnt come to know the status
and it shows executing status.
from
Doller
Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled
it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success altho
ugh
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
> --
> Travis Tan|||Travis wrote:
> Hi ,
> I created a batch only to transfer the files from local server to share
> folder on another server. I put the batch in the DTS package and scheduled
it.
> When I trace the job , the file have been copied but the "Status" of the
> job still stick on "Executing Step 1 ..." and it no turn to success altho
ugh
> the file had been copied. What's wrong with that actually ?
> Thanks ,
> Travis
>
Are you looking at the status in Enterprise Manager? In that case you
might need to refresh it to see the actual status.
Regards
Steen|||Hi Doller ,
Thanks for your info and I understand what you said. The actually process
in DTS was
1) Transfer The Files
2) UnZip The Files
3) Restore the transaction logs
Because the Transfer Files pending in "executing" so no Unzip process is
done. Means that no way for me to resolve that ?
Thanks ,
Travis
Travis Tan
"doller" wrote:

> Hi ,
> why u are making ur work complex .
> U can transfer the files using file tranfer protocol task in DTC
> package.
> When the batch finishes tanfer sqlserver doesnt come to know the status
> and it shows executing status.
> from
> Doller
>
> Travis wrote:
>