Where are misfires recorded?

Five Stars

Where are misfires recorded?

When looking at the TimeLine tab on the TAC server I can see that some jobs are misfiring but this isn't recorded in the TaskExecutionHistory table. I've had a look through the other tables but it doesn't seem to be recorded in any of them. If I look in TimeLine then it shows the missed start times for the jobs so wouldn't seem to be doing a dynamic calculation.

 

I'd like to be able to query this data from the database side to produce a full, easily readable, report for our daily checks. I can currently get the results for all the jobs that worked and failed but not misfires.

 

Does anyone know where or how these misfires are recorded?


Accepted Solutions
Five Stars

Re: Where are misfires recorded?

Ok so I've worked out the issue. They are in the ExecutionHistoryTable but don't have a TaskStartDate assigned so when looking for results in a time range these errors are ignored as the TaskStartDate is outside the range.

It would seem that the only way to see those within a time range is to find the Highest and Lowest ID assigned to data in the table for the time range and then search using those as your defining options.


All Replies
Moderator

Re: Where are misfires recorded?

Hi,

Do you mean MISFIRED events in the grid of task execution history?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Where are misfires recorded?

Yes. Are they somewhere in the database as they appear in the TimeLine but not in the Execution History table.

Regards

 

Five Stars

Re: Where are misfires recorded?

Ok so I've worked out the issue. They are in the ExecutionHistoryTable but don't have a TaskStartDate assigned so when looking for results in a time range these errors are ignored as the TaskStartDate is outside the range.

It would seem that the only way to see those within a time range is to find the Highest and Lowest ID assigned to data in the table for the time range and then search using those as your defining options.