How to trigger MSRS jobs from the command line

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: How to trigger MSRS jobs from the command line

mk52

How to trigger MSRS jobs from the command line
Posted: Wednesday, November 11, 2009 5:25 PM (GST)

Is there a way to trigger an MSRS (SQL 2005) job from the command line? I know that every job creates a SQL agent job, so there might be way to trigger that job from command line, but I was wondering if there is a more direct way of calling a MSRS report? thanks, Melik

Comments:

Author Thread:

William Vaughn

How to trigger MSRS jobs from the command line
Posted: Thursday, November 12, 2009 5:27 PM (GST)

Sure, when you use Report Manager to launch any report you can replay that URL from a commandline to launch the report. Frankly, I would use the ReportViewer control (as described in Chapter 14 of my HHG VS and SQL Server 7th Edition) to launch the report.

I'll be writing a whitepaper on passing parameters via URL when I return from vacation (starting today and ending in early December).

mk52

How to trigger MSRS jobs from the command line
Posted: Thursday, November 12, 2009 7:16 PM (GST)

In my case I have a job that creates an Excel extract. What I wanted to do was trigger the creation of the extract via command line since we use an Enterprise scheduler product for all jobs. Wouldn't the URL just return the web presentation of the report? Is there a way to just start the job/task that runs the report and saves it as an Excel file?

William Vaughn

How to trigger MSRS jobs from the command line
Posted: Friday, November 13, 2009 2:05 AM (GST)

IIRC there is a "render" operator that also works in the URL that we discuss in later chapters.