I get repeated log messages about a timeout running dbo.PurgeScheduleHistory. AFAICT this Scheduled Task never completes for me.
2018-02-12 04:51:54,141 [EC2AMAZ-9526KNG][Thread:45][ERROR] DotNetNuke.Data.PetaPoco.PetaPocoHelper -  Error executing SQL: ;Exec dbo.PurgeScheduleHistory
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
2018-02-12 04:51:54,142 [EC2AMAZ-9526KNG][Thread:45][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. --->
I ran the SP manually. It took 5m06s. I thought it was probably clearing out a ton of old data. I immediately ran it again, presumably now with no old data to clear out. This time it took 5m01s. Essentially the same time.
Both are hugely over the default 30 seconds ADO .Net allows for a command to execute.
@Sebastian - is this something that your turbo scripts would help with?
I am also curious in general. There is nothing very special about my system, it's not even particularly full of data. Does this script fail for everyone?