[Foreman 1.9.1] Tasks/Jobs Cleanup in DB

Support
1

Hi Guys,

I want to clean-up my jobs/tasks in the GUI via the DB, do you see a
problem by running the below commands? Sorry for the maybe stupid question,
but I´m not a DB Expert…

for the Tasks:
delete from foreman_tasks_tasks;
delete from foreman_tasks_locks;

for the Jobs:
delete from template_invocation_input_values;
delete from template_invocations;
delete from job_invocations;

thanks,
Christian

2

Hi,

we have a cleanup task in foreman-tasks for being able to do the job, see more details here, and
ask for more info if needed:

https://github.com/theforeman/foreman-tasks#tasks-cleanup

Regards

– Ivan

··· ----- Original Message ----- > Hi Guys, > > I want to clean-up my jobs/tasks in the GUI via the DB, do you see a > problem by running the below commands? Sorry for the maybe stupid question, > but I´m not a DB Expert... > > *for the Tasks:* > delete from foreman_tasks_tasks; > delete from foreman_tasks_locks; > > *for the Jobs:* > delete from template_invocation_input_values; > delete from template_invocations; > delete from job_invocations; > > thanks, > Christian > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to foreman-users+unsubscribe@googlegroups.com. > To post to this group, send email to foreman-users@googlegroups.com. > Visit this group at http://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout. >
3

Thanks again, working perfectly for Tasks, but for Jobs I see that Feature
#11993 is opened…anyway I used for the meantime my SQL Commands

··· On Tuesday, October 20, 2015 at 10:44:10 AM UTC+2, Ivan Necas wrote: > > Hi, > > we have a cleanup task in foreman-tasks for being able to do the job, see > more details here, and > ask for more info if needed: > > https://github.com/theforeman/foreman-tasks#tasks-cleanup > > Regards > > -- Ivan > > ----- Original Message ----- > > Hi Guys, > > > > I want to clean-up my jobs/tasks in the GUI via the DB, do you see a > > problem by running the below commands? Sorry for the maybe stupid > question, > > but I´m not a DB Expert... > > > > *for the Tasks:* > > delete from foreman_tasks_tasks; > > delete from foreman_tasks_locks; > > > > *for the Jobs:* > > delete from template_invocation_input_values; > > delete from template_invocations; > > delete from job_invocations; > > > > thanks, > > Christian > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "Foreman users" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to foreman-user...@googlegroups.com . > > To post to this group, send email to forema...@googlegroups.com > . > > Visit this group at http://groups.google.com/group/foreman-users. > > For more options, visit https://groups.google.com/d/optout. > > >
4

Yes, it was not prioritized right now, so waiting for next development iteration, but still, should be done
quite timely

– Ivan

··· ----- Original Message ----- > Thanks again, working perfectly for Tasks, but for Jobs I see that Feature > #11993 is opened....anyway I used for the meantime my SQL Commands > > On Tuesday, October 20, 2015 at 10:44:10 AM UTC+2, Ivan Necas wrote: > > > > Hi, > > > > we have a cleanup task in foreman-tasks for being able to do the job, see > > more details here, and > > ask for more info if needed: > > > > https://github.com/theforeman/foreman-tasks#tasks-cleanup > > > > Regards > > > > -- Ivan > > > > ----- Original Message ----- > > > Hi Guys, > > > > > > I want to clean-up my jobs/tasks in the GUI via the DB, do you see a > > > problem by running the below commands? Sorry for the maybe stupid > > question, > > > but I´m not a DB Expert... > > > > > > *for the Tasks:* > > > delete from foreman_tasks_tasks; > > > delete from foreman_tasks_locks; > > > > > > *for the Jobs:* > > > delete from template_invocation_input_values; > > > delete from template_invocations; > > > delete from job_invocations; > > > > > > thanks, > > > Christian > > > > > > -- > > > You received this message because you are subscribed to the Google > > Groups > > > "Foreman users" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > an > > > email to foreman-user...@googlegroups.com . > > > To post to this group, send email to forema...@googlegroups.com > > . > > > Visit this group at http://groups.google.com/group/foreman-users. > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to foreman-users+unsubscribe@googlegroups.com. > To post to this group, send email to foreman-users@googlegroups.com. > Visit this group at http://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout. >