Case structure is what I thought too, but I tested the "msdb.dbo.sp_sqlagent_has_server_access system" stored procedure that the job uses to validate server access with all variations of upper/lower case names...

I think I figured out the problem. We have a Windows group that we designate for read-only access to the SQL server. That Windows account is added to Logins. Then...

I was involved with a similar scenario when I came across this posting. I modified the code which should work as expected. Notice that even though I'm using SELECT *...,...