SQL Server Performance Forum – Threads Archive

Cannot see the JOBS

I have an user with all rights to the database and he cannot see the jobs to monitor
any ideas why?
thanks

---

I assume you are talking about EM.
Did you try from other PC?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

Hi,
if you have scheduled any job and wants to see the satus run : select * from msdb..sysjobhistory and if you wants to see history run :
select * from msdb..sysjobs select * from msdb..sysjobschedules
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

---

No I don’t want to see the status, the user cannot see the job itself from any computer when he login with his rights.
Witch right I need to give to the user to be able to see the jobs?
thanks

---

You said that allready the user has all rights, that include admin?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

I guess the user has DBO rights in his database. DBO right in a database is not enough to view / monitor the scheduled jobs. If a user is not an admin (sa or sa equivalent) in the SQL Server, he can view / monitor the jobs which are owned by him.
/* SKChandra */
http://www.skchandra.com

---

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;283811&sd=tech for refernce on jobs. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Yes but any one know of a way of giving a user rights to view jobs, with out sysadmin. I am guessing there will be a sp in msdb?

---

Hi, Try adding the users to the TargetServersRole role in the msdb database. Karl Grambow www.sqldbcontrol.com

---

..this applicable since SQL 2000 SP3a onwards and prior to this you may not be able to. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

i guess thats the issue with the sql server agent next2none is what others feel about the maverick

---

Not an issue within the SQLagent, there are few changes to permissions between SP3a and SP4 in SQL 2000 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

]]>