How To View Jobs in Enterprise Manager

[kim1]

Hi

I have an User account that has db_ddladmin database role permission. I did Grant access to table, view and stored procedure of msdb database to this user, but still not be able to view the jobs in Enterprise Manager the list of Jobs in Jobs folder.

I can view the jobs in SQL Analyzer but NOT in Enterprise Manager. Is there any way to let this user to view all the job without assigning this user account db_owner permission?

Thank you for your help

Kim

 

[aalmeida]

db_owner would not allow them to see it any way since it is a database role and the jobs are server role you need to assign to them a server role try processadmin server role. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[kim1]

processadmin server role doen't list the Job neither.

I don't want to set the the account to sysadmin.

thank you for your suggestion.

Any other suggestions?

Kim

 

[aalmeida]

- processadmin - Can manage processes running in SQL Server. after you assigned this server role did you have the client restart? and reconnect?

if you did, what about
- securityadmin - Can manage logins and CREATE DATABASE permissions, also read error logs and change passwords. ?
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[kim1]

Hi Al,

Thank you for responding to me. I did restart the client machine with processadmin, it doesn't see the jobs either.

I did try securityadmin, same thing.

I want to restrict the most permission to that account as possible. I have no idea how I can give permission to that account to view the job.

Thank you Al.

Kim

 

[aalmeida]

This is from BOL special attention to the 3rd line
How to view a job (Enterprise Manager)
1st - To view a job Expand a server group, and then expand a server.
2nd - Expand Management, expand SQL Server Agent, and then click Jobs. In the details pane, right-click a job, and then click Properties.
3rd - You can only view jobs that you own.

The only exception to the 3rd line is if you have sysadmin server role. What you could try then is to create your own Special Role to allow them to see it
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[kim1]

Hi Al,

Do you mean that AccountA cannot see jobs created by AccountB and vice versa. Only sysadmin server role can view all jobs. There is no other way but assigning a new role with sysadmin server role to allow AccountA to view the job owned by someone else? If that is the case, I am in a big trouble.

Thank you very much Al for your response.

Kim Kim