administering jobs and targetserversrole

My goal is to allow my developers to create and modify jobs on our
development server. To this end, I have put the developers (who are dbo in
their respective db), in an nt group and put them in the targetserversrole
in msdb on the server. In addition, by changing the role and granting
execute to the add,delete,and update job stored procedure groups and the job
start and stop stored procedures I am able to allow the group to add and
modify jobs, except for one item in the job and that is to set up job
notifications. I have tried granting the add,update and delete notification
group but that doesn't do it as the check boxes are still disabled for the
developers when they look at that part of the job. Does anyone know what I
am missing in this plan? Thanks in advance for any help solving this.One of the problems with this approach is that it's not
documented or supported. The role really isn't meant to be
used outside of SQL Server using it for MSX. If you use this
role, you will find that things change if/when you apply SP3
and who knows what other service packs or fixes may change
the functionality of the role.
-Sue
On Tue, 4 May 2004 09:12:53 -0400, "MarkR"
<mrussell@.dasny.org.dontspamme.net> wrote:

>My goal is to allow my developers to create and modify jobs on our
>development server. To this end, I have put the developers (who are dbo in
>their respective db), in an nt group and put them in the targetserversrole
>in msdb on the server. In addition, by changing the role and granting
>execute to the add,delete,and update job stored procedure groups and the jo
b
>start and stop stored procedures I am able to allow the group to add and
>modify jobs, except for one item in the job and that is to set up job
>notifications. I have tried granting the add,update and delete notificatio
n
>group but that doesn't do it as the check boxes are still disabled for the
>developers when they look at that part of the job. Does anyone know what I
>am missing in this plan? Thanks in advance for any help solving this.
>
>

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USA
My favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>
|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>

admin tool for MSDE?

What admin tools are developers using for MSDE applications? If SQL Server
Enterprise Manager is unavailable and the Web Access tool is just too
clunky, what else is popular?
Thanks,
Bill
Cincinnati,OH USAMy favourite (if EM is not applicable) is QALite which is a really cool tool
for scripting and other things, just try this.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
> What admin tools are developers using for MSDE applications? If SQL Server
> Enterprise Manager is unavailable and the Web Access tool is just too
> clunky, what else is popular?
> Thanks,
> Bill
> Cincinnati,OH USA
>|||Hi,
DBARTISAN from embarcadero is also really good for administering SQL Server.
http://www.embarcadero.com/products/dbartisan/
Thanks
Hari
SQL Server MVP
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OLBhrfQSFHA.1268@.TK2MSFTNGP14.phx.gbl...
> My favourite (if EM is not applicable) is QALite which is a really cool
> tool for scripting and other things, just try this.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Bill" <usenet@.spoofed.com> schrieb im Newsbeitrag
> news:7dc07$426bf7cd$d8c4ff3d$14512@.FUSE.NET...
>> What admin tools are developers using for MSDE applications? If SQL
>> Server
>> Enterprise Manager is unavailable and the Web Access tool is just too
>> clunky, what else is popular?
>> Thanks,
>> Bill
>> Cincinnati,OH USA
>>
>