Re: View but not execute jobs

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 06/29/05 

Date: Wed, 29 Jun 2005 22:22:36 +0200

Here you can also find the only viewing of the job status:

http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/795ec20703b7b535/440f861a2c394474?q=sp_help_job+Jens&rnum=1#440f861a2c394474

In Common you should llok for sp_help_job which will extract the information
from the system tables, sysjobs,sysjobsteps,sysjobhistory (names should be
something like that) 

-- 
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Andy" <Andy@discussions.microsoft.com> schrieb im Newsbeitrag 
news:DF85BB2D-0E74-4721-88B7-365280F372F7@microsoft.com...
> Is there a security setting that ables users to view jobs and their 
> status,
> history, etc. but unable to execute them?

Relevant Pages

  • RE: Very easy question about filter!!!
    ... Extracting Values Common To Two Lists ... You can easily extract values that appear in both of two lists. ... > I would like to have a third column if john, ...
    (microsoft.public.excel.misc)
  • Re: duplicates
    ... Extracting Values Common To Two Lists ... You can easily extract values that appear in both of two lists. ... an array formula needs to be committed with control & ...
    (microsoft.public.excel.programming)
  • Re: Question about removing duplication: inheritance vs static methods
    ... >something common extract superclass with common code(using 'Template' or ... subclasses become dependent from superclass which can change. ... > Second way is to extract static methods and put it in util classes. ... Then put it back until you know where to attach it:-) As above, ...
    (comp.object)
  • Re: vlookup
    ... is on extracting values common to two lists, ... > I want to be able to use lookup to extract values common to two list. ...
    (microsoft.public.excel.newusers)
  • Re: New article on Sampras: he needs to stay away
    ... for viewing. ... It's clear Fed was spinning in his serve throughout the ... Bad analysis we all know is common here....but to get basic ...
    (rec.sport.tennis)