[MSNoise] Re-setting jobs from 'D'one to 'T'odo

[Thomas Lecocq]

Aurélien,

it is OK to do so, but you might want to set the CC jobs only, and only 
those marked "I"n progress...

update jobs set flag="T" where type="CC" and flag="I";

is another example.

I'll try (before AGU) to release a "msnoise-toolbox.py" to execute those 
commands automatically...

Cheers,

Tom

Le 20/10/2014 17:45, Aurélien Mordret a écrit :
> Dear Thomas, dear MSNoise users,
>
> No problem to fix, just a tip.
>
> For people who are not familiar at all with MySQL (like me), here is how to
> reset the correlation computation jobs from 'D'one to 'T'odo between a
> certain range of dates. I needed to do that because the disk where I wrote
> the correlations get full, but MSNoise kept trying to do the following job
> even if the correlation couldn't be written. Actually, maybe there is a way
> to let the job set to 'T' if the correlation is not really saved on a
> disk...
>
> Anyway, here is the command I used in phpMyAdmin, using the SQL tab, once
> you selected your database:
>
> UPDATE `job` SET `flag` = 'T' WHERE `day` BETWEEN 'date1' AND 'date2';
>
> Then press Go button.
>
> Before using it, I would like to have the advice from a MySQL expert: is it
> the right way to do it? If yes, it could be worth to have this line in the
> documentation somewhere.
>
> Cheers,
>
> Aurelien.
>