Unable to view Jobs in Enterprise Manager

[kim1]

Hi,

I use an user-defined account called Developer and have only db_ddladmin as role permission for this account. I cannot see the list of Jobs in the Jobs Folder in Entreprise Mananger.

I don't want to give the db_owner or sysadmin to the Developer account, but I do want them to see the list of jobs on Enterprise Mananger.

Is there any way I can this.

Thank you very much for you help.

Kim

 

[aalmeida]

yes gid the Developer read permition to the msdb db and let them run the following query on msdb:
select * from sysjobs AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[kim1]

Hi,

Is there any way I can let them view in Enterprise Mananger instead of in Query Analyser with select * sysjobs.

Thank you for you help.

Kim