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...

WHOO HOO! I've had 2 sessions accepted!

Disaster Recovery: Preparing for the Storm and The Nitty Gritty of Database Backups. Both beginner level sessions. Better start working on my power...

Gosh darnit. Something must be wrong with my site PM & Email.

Ninja, send me an email to goldpetalgraphics@yahoo.com. I'll reply with a different email address from allstate, but I don't...

Apparently my PM isn't working. Go to my profile and send me a personal email and I'll reply. And if you don't hear back from me by the next, post...

I don't know if this will work (because we can't get checkpoint files working properly on our cluster right now), but you might look into setting up checkpoint files on...

Oddly enough, I think this issue is a cluster problem.

The cluster administrator says MSDTC is running on the cluster (on our V1 node), but my report server is on the...

gkostin, we love to help. Helping teaches us the things we don't know. @=)

Jason, thanks. I love compliments. @=)