I found table with over than 60 Millions records. So I created daily schedule to delete records older than 7 days. The schedule is running 18 hours and there are deleted less than 1 Million records. The problem is performance, whole system slowes down.
In the meantime i stopped creation of new records in this table, so it won't be filled so quickly.
Now I need to stop my schedule job. How to do this without stopping whole server? Is there possible?