Using a SSRS Report to run SQL Agent Jobs

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  Using a SSRS Report to run SQL Agent Jobs
 
0
/5
Avg: 0/5: (0 votes)

Comments (7)

benagee
benagee said:
And I thought I was the only person who did updates and executed jobs using a report to kick it off.... lol. Seriously, this is good stuff and a lot simpler than creating a custom web page that allows them to have the same functionality.
12/2/2009
 · 
 
by
nitya
nitya said:
I wish I knew this earlier. Great tip
12/4/2009
 · 
 
by
paschott
paschott said:
Guess I'm gonna have to give this a try (after I find the time to write the report). This is definitely easier than trying to figure out which of the many GUID-named Agent Jobs is the one that I actually want to run. (Which leads to the inevitable "what was MS thinking" question.) I really wish I had some control over what the corresponding job name would be to start with, but at least this way I can look it up. Thanks for the tip.
12/11/2009
 · 
 
by
DevinKnight
DevinKnight said:
Peter I'm writing a new part 2 to this blog post now that will help you with selecting which job you want to run.
12/11/2009
 · 
 
by
meganathank
meganathank said:

Clever way to start the job and more secured way too Cool

2/18/2011
 · 
 
by
sqllion
sqllion said:
One of the effective and correct way to get the job Running Status report in SSRS for easy viewing and monitoring jobs running on servers. (.rdl file attached.) http://www.sqllion.com/2011/11/job-running-status-report-in-ssrs/
11/30/2011
 · 
 
by
user056764
user056764 said:
Thanks for a very good tip. Thinking of using this, but I want to control when the dataset runs. Anyone have a good idea of how I can do this? Ex. by a parameter when = 1 or something?
10/10/2012
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts