Re: JOBS

From: Roberto Carrasco (roberto_carrasco_at_msn.com)
Date: 09/30/03 

Date: Tue, 30 Sep 2003 12:32:46 -0700

Hi Sue, thanks for your reply ! ! When in the graphical
interface If I execute a step that has 60 steps SQL Show
EXECUTING STEP 5, Refresh ! EXECUTING STEP 33, The user
that owns the job must see this information ! Using
SP_HELP_JOB I don't have this information. and the users
owns the job ! I don't understand

>-----Original Message-----
>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 !
>>>>
>>>>
>>>>.
>>>>
>>>
>>>
>>>.
>>>
>
>.
>

Relevant Pages

  • Re: Millions of Delete Statements
    ... You mention a cursor. ... Others have mentioned batching the commands, ... so I will throw out one that is less good (executing them ... get the whole SQL statement I don't know of another way to do it). ...
    (comp.databases.ms-sqlserver)
  • Re: Poor performance when executing stored procedure
    ... If SQL Server ... has to re-compile the SP, it takes shorter time to compile a smaller stored ... Poor performance when executing stored procedure ...
    (microsoft.public.sqlserver.programming)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: Security level to run SP_OA... Procedures
    ... I'm not sure why you are executing sp_OA* procs here since you can ... sp_OA* procs as well as other master database stored procedures. ... Configure the SQL Agent proxy account. ...
    (microsoft.public.sqlserver.security)
  • Re: Oracle11 & statistics calculations
    ... but it did show me that the "counting" SQL is ... elapsed = elapsed time in seconds executing ... user SQL statements in trace file. ... internal SQL statements in trace file. ...
    (comp.databases.oracle.server)