SQL Server Reporting Services Running Jobs

SQL Server Management Studio has a jobs node to control running jobs in SQL Server.  There is also a Manage Jobs page on Report Manager.  In both cases this is something you would not want your users to have access to.  You might want your users to be able to see the current running jobs without giving them access to SQL Management Studio or the admin page.  You can create a Reporting Services report to display running jobs that are over 60 seconds in duration by using the following query.

select  UserName,

                StartDate,

                RequestName,

                RequestPath,

                Timeout,

                JobAction,

                JobType,

                JobStatus

from    dbo.RunningJobs,

                dbo.Users

where   RunningJobs.UserID = Users.UserID;

 

Advertisements
This entry was posted in SQL Server Reporting Services. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s