HI

I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help.

Thanks
Tank50

Hi

Thanks for Reply.I found the how to do this.First create server loging sql server 2005.After that in user mapping select msdb table and select role as sqlagentuser role.

Thanks
Tank46

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.