Saturday, February 25, 2012

Agent job owner/visibility

Windows 2000, SQL Server 2000 SP 4, Windows Authentication. We have several
developers, all in a Windows domain group, and when one developer creates an
Agent job, that job is owned by that one developer and is not visible by the
other developers. Is it possible to have a job be owned by a login that
corresponds to a Windows domain group? The Owner dropdown in EM seems to
indicate it's not possible, because no groups (domain or local) are listed.
We are not in the sqladmin group, nor in the local Windows Administrators
group.
Thanks
Vern RabeVern
Has this Windows Domain Group a login to SQL Server?
What are permissions to the login?
"Vern Rabe" <VernRabe@.discussions.microsoft.com> wrote in message
news:DA097453-1559-45B5-BB2C-E45A3180DA3F@.microsoft.com...
> Windows 2000, SQL Server 2000 SP 4, Windows Authentication. We have
> several
> developers, all in a Windows domain group, and when one developer creates
> an
> Agent job, that job is owned by that one developer and is not visible by
> the
> other developers. Is it possible to have a job be owned by a login that
> corresponds to a Windows domain group? The Owner dropdown in EM seems to
> indicate it's not possible, because no groups (domain or local) are
> listed.
> We are not in the sqladmin group, nor in the local Windows Administrators
> group.
> Thanks
> Vern Rabe|||Uri:
Yes, we have a login to SQL Server for that Windows Domain Group. I don't
believe the login is in any fixed server roles.
I may have separately found the solution, however. I have requested the DBAs
to add the login to the TargetServersRole in the msdb database. Haven't
tested yet (or even gotten their approval to do it), so we'll see.
Thanks
Vern
"Uri Dimant" wrote:

> Vern
> Has this Windows Domain Group a login to SQL Server?
> What are permissions to the login?
>
> "Vern Rabe" <VernRabe@.discussions.microsoft.com> wrote in message
> news:DA097453-1559-45B5-BB2C-E45A3180DA3F@.microsoft.com...
>
>

No comments:

Post a Comment