August 22, 2007 at 8:54 am
We are in the process of locking down our Production SQL Server instances, we have a mixture of SQL 2000 and SQL 2005. Up until now a small group of senior developers have had SA rights. The new direction is to have all production changes routed through the SQL Server DBAs. We would like the developers to still be able to monitor job statuses and restart the jobs as necessary. Is there an off the shelf software package that would allow us to provide and inteface for job monitoring and starting? Any thing we have tried to limit their access in Enterprise Manager has immediatly prevented them from seeing the current job status and restarting jobs.
August 22, 2007 at 9:47 am
you generally have to make them dbo of msdb database. Monitoring you can do through web assistant or reporting services or asp.net which allows users with no access to sql server to view jobs - write it yourself- not a difficult query. I'd actually question why you need to let developers run jobs if you're going to lock down the system.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 22, 2007 at 11:31 am
Another option is just to grant them membership in
msdb database roles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply