Post reply

Jobs Status Not refreshing

  • November 12, 2007 at 7:31 am

    #118815

    I am trying to give access to Support team to view status of Jobs and if needed to Start any job.

    Every thing is working fine by adding System Team to targetServerRole in msdb. and granting execute permission on sp_start_jobs sp. Adding users to RepositoryUser is also not helping.

    But support team can't see status of jobs , when they resfres a job. Could you help me in sorting out this issue.

    Regards

    Deepak Khattar

  • November 13, 2007 at 7:56 pm

    #750907

    You can use sp_help_job to find out the job status.

    EXEC msdb..sp_help_job

    @job_name = 'Job'

    ,@job_aspect = N'job'

    This will come back with a result set, the column current_execution_status identifies the status of the job at that moment.

    1 = Executing.

    2 = Waiting for thread.

    3 = Between retries.

    4 = Idle.

    5 = Suspended.

    7 = Performing completion actions.

  • November 14, 2007 at 7:39 am

    #751094

    Its for the support team , they have to keep an eye on failed/running jobs and they like EM

    Deepak

Viewing 3 posts - 1 through 3 (of 3 total)

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