Sensitive information should NEVER be included in a configuration if you can avoid it. If you can't avoid it, don't use XML or any other feature that leaves the password...

Pretty similar, yes. @=)

Okay, I see what you're saying now.

Sorry about the dizoid moment. Thanks for your help!

Riga,

In every and any instance, the correct answer is "It Depends". @=)

Which configuration file is easier for you depends on how your environment is set up.

For my workplace, our...

Thanks for the link, Peter.

I just noticed something interesting and annoying.

When I add the system db roles to JobOperator, it makes JobOperator the owner of those schemas. When I go into Schemas and change...

Ed,

I can't add JobOperator to SQLAgentOperatorRole. It doesn't show as available when I try. So how am I supposed to get this to work?

I created a role in msdb called "JobOperator" with the owner of "dbo". I assigned other roles to it rather than specific permissions. The roles assigned are as follows:

SQLAgentUserRole

SQLAgentOperatorRole

db_datareader

SQLAgentReaderRole

db_dtsadmin

Then I...

Well, I figured out what the problem was. I tried assigning all these permissions to a database role and then adding the user to the database role and no matter...

Me too. Which means I can't fiddle with SQL 2008 nearly as much as I want to.

@sob!

I tried instance level refreshing and it didn't work. I'm going to try again tomorrow. It might be a cache refresh issue on the user's PC if other people are...

Well, see, that's what I wasn't sure about. How the global policies in 2008 actually functioned under the hood, that is.

I'm referring to a situation that I ran into with...

Michael,

I appreciate the response, but it didn't work. The user still can't see any of the jobs or even open the Job Activity Monitor. SQL Server Agent isn't even...

I look forward to meeting you, Jack! @=)

Nope. I spoke at the Jacksonville, Florida SQL Saturday also. It's funny. I subbed for the Backup / Restore session at the last moment and found out I knew more...