New release: SQL Monitor Version 12.0 is now available. Read more.

Configure Job Duration logic

we have a good number of jobs that run to see if there is a file present, if so it takes awhile to run, otherwise it takes generally under a second.  Is there a way to configure the Job Duration Unusual alert or the formula to only include job executions over xx seconds or something like that?  That would be a much more accurate averages, at least in our cases.

Answers


  • Thanks for reaching out to us regarding this.

    Unless I am misunderstanding your question, then yes it is possible to configure this by increasing the 'Don't raise an alert i the job run time is less then .... seconds' setting on the alert configuration page.








    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • That would not do what I am seeking, that would keep the alert from firing if it takes longer than xxx seconds (120 in screenshot).  What I want is do is to eliminate the times from the computed average that are less than 2 second (for example) then the average duration would be an average of runs when it had work to do.  So if the last 20 run were as follows (in seconds)
    0,0,0,.5,10,5,.5,0,1,18,20,1,0,0,0,12,1,5,1,0
    avg of last 10 =3.4
    avg tossing out < 2 = 10.8
    10.8 is a more realistic time the job spent, so raise alerts when job takes 15 sec or more, right now getting alerts for “normal” run durations, as even 2x avg is still way under normal.

    I briefly tried to see if I could configure custom metric, but didn’t get very far.

    thanks
Sign In or Register to comment.