Post reply

See Jobs Executing

  • November 15, 2006 at 1:13 pm

    #61948

    Hi, 

    I have helpdesk users I need to grant the ability to see jobs running or not in enterprise manager.

    This is the current status not the history.  I've given the permissions I think they need but still no joy...

    Any advice would be appreciated.

     

    Thanks

    Gareth

  • November 15, 2006 at 1:50 pm

    #672126

    You need him privileges to access to sysjobs, sysjobhistory, sysjobsteps. 

  • November 16, 2006 at 7:28 am

    #672274

    To see executing jobs in Enterprise Manager you need to be SA. The only way around this is to hack the system stored procedure, if you are up to it, msdb.dbo.sp_get_composite_job_info and hard code

    SELECT

    @is_sysadmin = ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0)to

    SELECT

    @is_sysadmin = 1

    Personally I don't like hacking system procs, but in this instance, it is far better than making the user SA.

    Terry

     

  • November 16, 2006 at 8:09 am

    #672303

    Hacking the System stored procedure may put you into an unsupportable instance of SQL server.  so you may want to rethink that...

    You could create a stored procedure that gather the appropriate information from sysjobs, sysjobhistory, sysjobsteps abd then grant him permission to run that stored procedure. 

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • November 16, 2006 at 1:23 pm

    #672440

    I was afraid it might be something like that.  That's a real pain, I'd rather not hack the sp, but it is definitly better than making them SA.  Is their any improvement to this situation under 2k5?

  • November 16, 2006 at 2:05 pm

    #672449

    The stored proc still checks for SA in 05. There are some new agent permissions you can set, but so far, none I tested will show the current status of a job.

    Terry

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply