SQLAgent Jobs Not Available after SP4 Applied

From: Jason Delaune (JasonDelaune_at_discussions.microsoft.com)
Date: 05/20/05 

Date: Thu, 19 May 2005 16:22:02 -0700

Hello all,

I have created a generic user for our developers to use as the owner of the
SQL Server jobs they create. This way all developers can use a generic
account to manage the jobs they create so that all developers can easily see
each other jobs. For the jobs that required administrator access, we setup a
proxy account. This all worked great when our server was running SP3a.

We recently applied SP4 to the server and now we are receiving all kinds of
permission problems. Now when our developers what to see the jobs using the
generic account (job owner) they get errors about permissions denied to the
xp_sqlagent_* extended stored procedures as well as various other xp_*
extended stored procedures within the master database.

What has changed with SP4 that would cause this problem? And what's the easy
way to fix it other than making the generic account dbo within the master
database?

Thanks,
Jason

Relevant Pages

  • Re: SQLAgent Jobs Not Available after SP4 Applied
    ... Have you applied the SP4 to their developer machines also. ... > SQL Server jobs they create. ... This way all developers can use a generic ... > way to fix it other than making the generic account dbo within the master ...
    (microsoft.public.sqlserver.security)
  • Re: Making money on open source, if not by selling _support_, then how?
    ... How could there be no day job available for GNU developers? ... The status quo is not even close to 100% open source. ... jobs "disappeared", or if you're more progressive you might say their ...
    (comp.lang.ada)
  • A boom or a mirage... in property ???
    ... their dream home for the last two weeks. ... Developers were ready with 'attractive' deals to unload ... buyers who will find themselves in deep water. ... jobs or fall sick. ...
    (soc.culture.singapore)
  • Re: A boom or a mirage... in property ???
    ... their dream home for the last two weeks. ... Developers were ready with 'attractive' deals to unload their unsold units. ... jobs or fall sick. ... Not only production operators, but factory managers ...
    (soc.culture.singapore)
  • Re: SQLAgent Jobs Not Available after SP4 Applied
    ... weren't even allowed to see the jobs. ... developers can see the jobs, but now they can't view or edit any of the job ... Microsoft really locked down the security on the SQL Agent in SP4. ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.security)