Re: JOBS

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/30/03 

Date: Tue, 30 Sep 2003 11:50:13 -0600

If the user executes sp_help_job to view information on the
job, can they see information on the job? If not, there may
be something wrong with their user accounts and you may want
to pursue correcting that issue rather than modifying system
stored procedures and having a non-supported server.
If they own a job, they can execute sp_help_job for that
job.

-Sue

On Tue, 30 Sep 2003 10:04:25 -0700, "Roberto Carrasco"
<roberto_carrasco@msn.com> wrote:

>What modifications do I have to do in the
>sp_get_composite_job_info to make it work !
>
>The users own's the job but he still can't see the status
>column being updated when running the job ??
>
>PLEASE ANSWER !
>
>>-----Original Message-----
>>Have a look at this http://tinyurl.com/of42 which is a
>reply to your earlier
>>post. Basic answer is no unless you want to risk possibly
>being unsupported
>>
>>--
>>HTH
>>
>>Jasper Smith (SQL Server MVP)
>>
>>I support PASS - the definitive, global
>>community for SQL Server professionals -
>>http://www.sqlpass.org
>>
>>"Roberto Carrasco" <roberto_carrasco@msn.com> wrote in
>message
>>news:0d6f01c381f3$78fcdf20$a001280a@phx.gbl...
>>Hi,
>>
>>I did that and I still can't do that !
>>
>>I can start byt when I choose refresh ! the job it doesn't
>>work, I would like to know if someone already done this
>>before !
>>
>>Thank's
>>
>>
>>>-----Original Message-----
>>>There are procs in the master db to do this,
>>sp_start_job, sp_stop_job etc.
>>>Give the user in question permission to exec these procs.
>>>
>>>--
>>>HTH
>>>Ryan Waight, MCDBA, MCSE
>>>
>>>"Roberto Carrasco" <Roberto_carrasco@msn.com> wrote in
>>message
>>>news:145201c381e2$9a731090$a301280a@phx.gbl...
>>>> Hi,
>>>>
>>>> Is there a way to give a permission to a user to
>>>> execute,stop,refresh all the jobs that are created in
>>the
>>>> SQL SERVER !
>>>>
>>>> Thank's !
>>>
>>>
>>>.
>>>
>>
>>
>>.
>>