I have a number of reports that are supposed to run on Saturdays and email out. Some do, but the majority end up stuck in the PENDING state. This has happened for the last few weeks but when I come in Monday morning, they run fine. They are currently set up as a system process ran y the system agent. I’ve tried splitting them between 2 processes, a single process, both synchronous and asynchronous and as separate reports ran by the system agent and with all these, I end up with 8-10 reports that are not going through. Anyone have any ideas?
I had a problem like this with month end reports and putting them all into a process set and not checking allow simultaneous make them all complete. Might be worth a try.
Tried this and still have a dozen reports that ended up stuck in a pending state over the last weekend.