SQL Server Performance

Job Status

Discussion in 'General DBA Questions' started by pradeepreddy_msis, Jan 3, 2006.

  1. pradeepreddy_msis New Member

    Hi,

    I want to write a SP which takes 3 input parameters job name, Date,and server. Depending on these 3 parameters I want the output like "Job completion Date Time" and "Duration of that job". Any one help me in this.

    Regards,
    Pradeep
  2. Luis Martin Moderator

    Run,

    Use msdb
    select * from sysjobs

    and take a look.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


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



  3. FrankKalis Moderator

    This should get you going<br /><pre id="code"><font face="courier" size="2" id="code"><br />SELECT j.name<br /> , DATEADD(s,h.run_time/10000*3600+h.run_time%10000/6000+h.run_time%100,CAST(h.run_date AS CHAR(<img src='/community/emoticons/emotion-11.gif' alt='8)' />)) <br /> AS Last_Run_Time<br /> , h.run_duration<br /> FROM dbo.sysjobhistory h<br /> JOIN dbo.sysjobs j ON j.job_id = h.job_id<br /></font id="code"></pre id="code"><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />

Share This Page