Re: Grant user to see the SQL Server job status

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 05/24/05 

Date: Tue, 24 May 2005 07:21:53 +0200

What about building up a view which selects the appropiate columns ? YOu can
give the user the appopiate permissions on the view.

USE Northwind
GO
CREATE VIEW dbo.JobView
AS
Select somecolumnsofthatcolumnse from msdb..sysjobs sj
INNER JOIN msdb..sysjobsteps sjs
ON sj.job_id = sjs.Job_id
GO

Select * from jobview 

-- 
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Swami" <Swami@discussions.microsoft.com> schrieb im Newsbeitrag 
news:85FECA89-84E8-4F98-A2E9-1C71CE56A413@microsoft.com...
> Hi
>
> I need to grant permission to the user to see the sql server job status
> through Enterprise Manager.  I did the following steps  but still these 
> users
> are not able to see the sql server jobs status.  Even few jobs are running
> these users always shows as " not running" .
>
> 1  Created a separate role to in MSDB to monitor daily sql servers jobs. 
> In
> this role granted target server roles and execute permission to few stored
> procs which the user can start and stop .
>
> 2 I dont want to give sysadmin rights to these users.
>
> Need your info
>
> Regards
>
> Swami
>
>
>
>