Differences

This shows you the differences between two versions of the page.

--- delete_old_avril_jobs [2019/03/02 11:58] – kalaschnikow
+++ delete_old_avril_jobs [2019/03/02 12:02] (current) – kalaschnikow
@@ Line 1: / Line 1: @@
+====== Delete old Avril jobs ======
+Org ids:\\
+: Articard\\
+: Scarabeus\\
+: Evorlatgale\\
+Millis calculator: https://codechi.com/dev-tools/date-to-millisecond-calculators/
+<code sql>
+-- check how much jobs are to delete:
+select count(*) FROM job where org_id=<my_org_id> and delMS > 0 and resolvedMS > 0 and resolvedMS < <time_millis>;
+-- after that delete them:
+delete FROM job where org_id=<my_org_id> and delMS > 0 and resolvedMS > 0 and resolvedMS < <time_millis>;
+</code>