Check Post Timesheets Job Performance

Products

• Clarity PPM SaaS

Issue/Introduction

Is there a way to check on the performance of the Post Timesheets Job?

Resolution

Contact the Support team if there is an inquiry into the performance of the job.

The following queries can be used to review the posting rate.

select DATE_TRUNC('hour', posted_time) day_hour, COUNT(1) as num_timesheets_processed 
FROM PRTIMESHEET where posted_time is not null
GROUP BY day_hour
ORDER BY day_hour desc