SQL Server Performance

Object Explorer and Active Jobs

Discussion in 'SQL Server 2005 General DBA Questions' started by mpex04, Sep 28, 2004.

  1. mpex04 New Member

    How do you find out the status of a particular job? In SQL 2000, I would simply go to SQL Agent, and the click on jobs. It would like all of the jobs with their current status. All I see in 2005 is a summary of the jobs without a way to sort or see the status. What am I missing?
  2. mpex04 New Member

    Could anyone point me to a place that could help with questions like this?
  3. Luis Martin Moderator

    Personally I don't like post without answers.
    I've installed 2005 and after some research, almost of SQLAgent funtions are not implemented yeat. Only history jobs. No way to see if running or not.
    So, you are missing nothing.

    HTH

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  4. ykchakri New Member

  5. satya Moderator

    Its still on the BETA and more features to come, in general you can use the statement SP_HELP_JOB or SP_HELP_JOBHISTORY for information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page