View job information - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

View job information

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 09:23:47

What access I should give for a non-admin user to be able to view the sql-job information?

------------------------
I think, therefore I am - Rene Descartes

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-05-15 : 09:32:40

SQLAgentReaderRole

Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 09:34:48

In MSDB.

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 09:36:08

Thanks ServerTeam and Sodeep.

------------------------
I think, therefore I am - Rene Descartes

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 09:50:34

Can I limit the access to specific jobs?

------------------------
I think, therefore I am - Rene Descartes

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 11:02:16

How to achieve this in SQL2K?

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 11:12:20

add user in Targetsvrrole in MSDB in SQL 2000.

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 11:16:12

Great! Thanks Sodeep.

------------------------
I think, therefore I am - Rene Descartes

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-05-15 : 12:02:43

Sodeep sry for troubling you..

if we add user to Targetsvrrole how can we limit user to particular job..

Sry if this question irritates you..

quote:
Originally posted by sodeep

add user in Targetsvrrole in MSDB in SQL 2000.

Thanks,
ServerTeam

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-15 : 12:07:41

Even I had this doubt. I have already asked this question.

------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 12:22:50

You can't limit to particular job

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources