Re: JOBS
From: Roberto Carrasco (roberto_carrasco_at_msn.com)
Date: 09/30/03
- Next message: Roberto Carrasco: "Re: See and execute JOBS ONLY"
- Previous message: Shelton: "Re: Cryptography API with SQL Server 2000..."
- Next in thread: Sue Hoegemeier: "Re: JOBS"
- Reply: Sue Hoegemeier: "Re: JOBS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Sep 2003 10:04:25 -0700
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 !
>>
>>
>>.
>>
>
>
>.
>
- Next message: Roberto Carrasco: "Re: See and execute JOBS ONLY"
- Previous message: Shelton: "Re: Cryptography API with SQL Server 2000..."
- Next in thread: Sue Hoegemeier: "Re: JOBS"
- Reply: Sue Hoegemeier: "Re: JOBS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
