Re: Read jobs only!.....
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
You can add them to the TargetServersRole in the msdb database. This will
allow viewing job properties and history but not modifying or running the
job. Note that they won't be able to tell if its running or not.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"tom d" <tomd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CEE1D321-1734-4AF8-A16C-433DFC5D8738@xxxxxxxxxxxxxxxx
> Hi All,
> Is there any way to allow developers to ONLY view jobs and job's histories
> without granting him/her local admin right to SQL server.
>
> I just want developers to view jobs ONLY, not allow them to make changes.
> How do I do this?
>
> Thanks in advance!
> Tom d
>
.
Relevant Pages
- Re: Question on conversion to ADP
... parameters through VBA/pass-through queries. ... help/guidance coming from Microsoft for Access developers trying to ... Microsoft Access or SQL Server 2005: ...
(microsoft.public.access.adp.sqlserver) - Re: Can relational alegbra perform bulk operations?
... Unlike in most other fields that are so expensive to participate in, the ironic aspect in IT is that the "free software" developers usually mimic what the commercial ... Many people recoil in horrors regarding its apparent disregard for transactions and foreign key support, but to me this makes perfect sense: If it's not needed, then the developer should be able to choose to not need it. ... Basically, they used SQL Server as a reporting server, loading data from Oracle DSS. ... The users just needs to aggregate data upon filters of their choosing and generate reports; no updates except to dump the data and load new dataset from Oracle on a regular interval. ...
(comp.databases.theory) - Re: [Bulk] Re: [opensuse] Quirks in a new v11.2 system
... history is important. ... Although KDE is not a profit making organization, ... have a very small user base, but that doesn't mean the developers lacked ... Personally I like the vision behind KDE4 and prefer it to the vision ...
(SuSE) - Re: How to create views with SQL-NS
... >> What programming language are you using for your Wizard? ... all of our developers have EM and QA. ... >>>creation within our security model that sits atop SQL Server. ...
(microsoft.public.dotnet.framework.interop) - Re: Efficiency concern of query, looking for input
... link with all rows in the history table prior to or equal to this date ... So to get all balances for all balance dates it seems ... again instead of reusing previous calculations. ... - Can or will MS SQL Server optimize this type of queries to do ...
(comp.databases.ms-sqlserver) |
|
