Agent job owner/visibility

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vern Rabe - 26 Jul 2005 20:42 GMT

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

Reply to this Message

Uri Dimant - 27 Jul 2005 03:33 GMT

Vern
Has this Windows Domain Group a login to SQL Server?

What are permissions to the login?

> Windows 2000, SQL Server 2000 SP 4, Windows Authentication. We have
> several
[quoted text clipped - 11 lines]
> Thanks
> Vern Rabe

Reply to this Message

Vern Rabe - 27 Jul 2005 16:50 GMT

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

> Vern
> Has this Windows Domain Group a login to SQL Server?
[quoted text clipped - 16 lines]
> > Thanks
> > Vern Rabe

Reply to this Message