PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 3/2/2018 10:26 PM by  LarryD
Benchmarking jobs' execution time
 4 Replies
 2 Subscribed to this topic
 64 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
SusanBarlow
Payroll Manager
Private
Basic Member
(10 points)
Basic Member
Posts:6


Send Message:

--
2/15/2018 6:03 PM
    I want to be able to graph the execution times of jobs/batch programs. Is there a data source I can use for this besides getting every users print manager history?
    Greg Moeller
    Private
    Private
    Veteran Member
    (4163 points)
    Veteran Member
    Posts:1487


    Send Message:

    --
    2/15/2018 6:15 PM
    You can start here: --- obvisously this returns all of the jobs in the job table, so you may want to just include from specific dates.
    SELECT USERNAME,JOBNAME,TOKEN,ACTSTARTDATE,ACTSTARTTIME,
    CAST(DATEADD(SECOND, FLOOR(ACTSTARTTIME / 10000) * 3600 + FLOOR(ACTSTARTTIME / 100) % 100 * 60 + ACTSTARTTIME % 100, 0) as time) as 'Start HH:mm:ss',
    STOPTIME,
    CAST(DATEADD(SECOND, FLOOR(STOPTIME / 10000) * 3600 + FLOOR(STOPTIME / 100) % 100 * 60 + STOPTIME % 100, 0) as time) as 'Stop HH:mm:ss',
    CONVERT(CHAR(8), DATEADD(SECOND, DATEDIFF(SECOND,CAST(DATEADD(SECOND, FLOOR(ACTSTARTTIME / 10000) * 3600 + FLOOR(ACTSTARTTIME / 100) % 100 * 60 + ACTSTARTTIME % 100, 0) AS TIME), CAST(DATEADD(SECOND, FLOOR(STOPTIME / 10000) * 3600 + FLOOR(STOPTIME / 100) % 100 * 60 + STOPTIME % 100, 0) AS TIME)), ''), 114) AS 'RunTime Duration'
    FROM gen.dbo.QUEUEDJOB
    WHERE STATUS = '63' AND CONVERT(VARCHAR(21),STOPDATE,101) = CONVERT(VARCHAR(21),GETDATE(),101)
    -- ORDER BY 'RunTime Duration' desc
    ORDER BY ACTSTARTDATE desc, ACTSTARTTIME desc
    SusanBarlow
    Payroll Manager
    Private
    Basic Member
    (10 points)
    Basic Member
    Posts:6


    Send Message:

    --
    2/15/2018 6:31 PM
    Much gratitude!
    Fire23
    Senior BDR
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    3/1/2018 5:56 PM
    Good afternoon Susan,

    Velocity has a proprietary software, called Velocity Zoom (www.velocityzoom.com), which helps to give you real time performance alerts, bechmarking information, and continuous improvement ideas.
    We would welcome the opportunity of speaking with you if you were interested in finding out more information about Batch Reporting.

    Regards,

    Nate
    LarryD
    APPLICATIONS DEVELOPER
    Private
    Basic Member
    (21 points)
    Basic Member
    Posts:7


    Send Message:

    --
    3/2/2018 10:26 PM
    She must have an MSSQL database rather than Oracle
    You are not authorized to post a reply.