It's all about the answers!

Ask a question

What happens at 3AM?

Sean F (1.3k232132) | asked Apr 02 '21, 12:19 p.m.

My standalone 702 server always jumps to life at 3AM and the processor starts thrashing for over an hour and the server becomes difficult to use.

I checked the schedule for DW and all the DW jobs are scheduled to run at 00.00 so it is not DW I don't think.

is there some other scheduled database activity that kicks off at 3AM and can it be changed to a different time?

Accepted answer

permanent link
Davyd Norris (2.0k117) | answered Apr 03 '21, 9:59 p.m.
Normally the DW has two sets of jobs - the core ones at the top run at midnight and the more intensive ones run at 3 from memory.

Check the schedule for the second set of jobs and see if that's it
Sean F selected this answer as the correct answer

One other answer

permanent link
Carol Watson (71015) | answered Apr 02 '21, 12:29 p.m.

 Hi Sean,

We're on, so not sure this applies, but we run this task nightly during the early hours (see RM Advanced Properties)..  Could it be something like that?


Sean F commented Apr 02 '21, 2:33 p.m.
Thanks Carol

That is disabled on my server value = -1

Your answer

Register or to post your answer.