Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: how to get the status of a sql job

    Hi Gurus,
    can any one help me to get the job status of a sql job.

    My requirement is as under
    ordinary user (not SA) will query pass job name as argument to stored procedure and sp has to give me the job status.

    Thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can use SP_HELP_JOB and a user who is not a member of the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns.

    Execute permissions default to the public role in the msdb database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •