Post reply

tsql query help

  • November 4, 2015 at 7:54 am

    #304836

    Hi SQL Experts,

    Looking for query which gives historical information of each job in below format. Query should include latest previous completion times as well. Output should include jobs which completed their execution as well as jobs which are currently running.

    Jobname,starttime,stoptime,CurrentElapsedTime,avgtimetaken, prevruncompletiontime1,prevruncompletiontime1

    Note: output Column format

    CurrentElapsedTime - should be dd:hh:mm:ss format

    avgtimetaken - should be dd:hh:mm:ss format

    prevruncompletiontime1 - should be dd:hh:mm:ss format

    prevruncompletiontime2 - should be dd:hh:mm:ss format

    Thanks in advance.

  • November 4, 2015 at 8:01 am

    #1837672

    think the following will help us all.....please read and post accordingly.

    thanks

    http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

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

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