push report via command line script

Is there a way to kick off a report using a command line script? For
instance, I want a report to run only after a certain table in the database
has been updated (monthly) and I would like the report emailed as a PDF to a
user. I cannot use the My Subscriptions to do this b/c I don't know when this
monthly batch job will finish each month. Also, I don't want to just send the
user a link to his report b/c I don't want him to have to log in to see it.
I was thinking, is there a way to kick off a report via a batch script, then
have it save somewhere as a PDF and then an email can be generated and attach
this file as an attachment. Unless there is some way that the My
Subscriptions page in RS can be set up to only generate a report when a
particular database table is updated.
Thanks!Depending on the delay you can accept... YOu might go ahead and create a
subscription which runs every 10 minutes.
When you want to kick it off, simply insert the appropriate row in the
subscriptions table you created, and within 10 minutes, it'll be done.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lucky Horseshoe" <Lucky Horseshoe@.discussions.microsoft.com> wrote in
message news:B8EEA02B-9789-4925-9246-158A792287DF@.microsoft.com...
> Is there a way to kick off a report using a command line script? For
> instance, I want a report to run only after a certain table in the
> database
> has been updated (monthly) and I would like the report emailed as a PDF to
> a
> user. I cannot use the My Subscriptions to do this b/c I don't know when
> this
> monthly batch job will finish each month. Also, I don't want to just send
> the
> user a link to his report b/c I don't want him to have to log in to see
> it.
> I was thinking, is there a way to kick off a report via a batch script,
> then
> have it save somewhere as a PDF and then an email can be generated and
> attach
> this file as an attachment. Unless there is some way that the My
> Subscriptions page in RS can be set up to only generate a report when a
> particular database table is updated.
> Thanks!|||Hi,
Thanks for your response. Let me make sure I have this right, I should set
up a Subscription to run every 10 minutes and then after the appropriate
database table is updated (which happens once a month) just wait 10 minutes
and then kick off my email and file attachment to the user?
Would this create a lot of overhead on the report server running the report
every 10 minutes? It takes about a minute to render (or slightly less).
Thanks, Lucky
"Wayne Snyder" wrote:
> Depending on the delay you can accept... YOu might go ahead and create a
> subscription which runs every 10 minutes.
> When you want to kick it off, simply insert the appropriate row in the
> subscriptions table you created, and within 10 minutes, it'll be done.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Lucky Horseshoe" <Lucky Horseshoe@.discussions.microsoft.com> wrote in
> message news:B8EEA02B-9789-4925-9246-158A792287DF@.microsoft.com...
> > Is there a way to kick off a report using a command line script? For
> > instance, I want a report to run only after a certain table in the
> > database
> > has been updated (monthly) and I would like the report emailed as a PDF to
> > a
> > user. I cannot use the My Subscriptions to do this b/c I don't know when
> > this
> > monthly batch job will finish each month. Also, I don't want to just send
> > the
> > user a link to his report b/c I don't want him to have to log in to see
> > it.
> >
> > I was thinking, is there a way to kick off a report via a batch script,
> > then
> > have it save somewhere as a PDF and then an email can be generated and
> > attach
> > this file as an attachment. Unless there is some way that the My
> > Subscriptions page in RS can be set up to only generate a report when a
> > particular database table is updated.
> >
> > Thanks!
>
>

Publish with RS gives HTTPS error

Your help is genuinely appreciated!
I'm having trouble using the example script file "PublishReports.rss".
At the command prompt I type in:
rs -i PublishReports.rss -s https://myserver/reportserver
and I get an error:
"The operation you are attempting requires a secure connection. (HTTPS)."
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Use https only if you have ssl installed on your server. Change it to be
http instead.
--
| From: "Greg Allan" <gregallan@.NOSPAMPLEASEtvl.com>
| Subject: Publish with RS gives HTTPS error
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Lines: 17
| Message-ID: <HA8Vd.19914$LN5.8021@.edtnps90>
| Date: Wed, 02 Mar 2005 01:23:51 GMT
| NNTP-Posting-Host: 207.216.242.138
| X-Trace: edtnps90 1109726631 207.216.242.138 (Tue, 01 Mar 2005 18:23:51
MST)
| NNTP-Posting-Date: Tue, 01 Mar 2005 18:23:51 MST
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!news.glorb.com!newsfeed2.telusplanet.net!newsfee
d.telus.net!edtnps90.POSTED!53ab2750!not-for-mail
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44268
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Your help is genuinely appreciated!
|
| I'm having trouble using the example script file "PublishReports.rss".
|
| At the command prompt I type in:
| rs -i PublishReports.rss -s https://myserver/reportserver
|
| and I get an error:
| "The operation you are attempting requires a secure connection. (HTTPS)."
|
|
|
|
| --= Posted using GrabIt =--
| --= Binary Usenet downloading made easy =--
| -= Get GrabIt for free from http://www.shemes.com/ =-
|
||||Hi Brad,
Sorry, typo in my first message.
I do have SSL installed on my IIS machine and when I try to publish to
https:// it says it can't find the server.
If I publish to http:// is says "The operation you are attempting requires a
secure connection (HTTPS)"
""Brad Syputa - MS"" wrote:
> Use https only if you have ssl installed on your server. Change it to be
> http instead.
> --
> | From: "Greg Allan" <gregallan@.NOSPAMPLEASEtvl.com>
> | Subject: Publish with RS gives HTTPS error
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | Lines: 17
> | Message-ID: <HA8Vd.19914$LN5.8021@.edtnps90>
> | Date: Wed, 02 Mar 2005 01:23:51 GMT
> | NNTP-Posting-Host: 207.216.242.138
> | X-Trace: edtnps90 1109726631 207.216.242.138 (Tue, 01 Mar 2005 18:23:51
> MST)
> | NNTP-Posting-Date: Tue, 01 Mar 2005 18:23:51 MST
> | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
> sul.t-online.de!t-online.de!news.glorb.com!newsfeed2.telusplanet.net!newsfee
> d.telus.net!edtnps90.POSTED!53ab2750!not-for-mail
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44268
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Your help is genuinely appreciated!
> |
> | I'm having trouble using the example script file "PublishReports.rss".
> |
> | At the command prompt I type in:
> | rs -i PublishReports.rss -s https://myserver/reportserver
> |
> | and I get an error:
> | "The operation you are attempting requires a secure connection. (HTTPS)."
> |
> |
> |
> |
> | --= Posted using GrabIt =--
> | --= Binary Usenet downloading made easy =--
> | -= Get GrabIt for free from http://www.shemes.com/ =-
> |
> |
>