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

Aurélien Mordret aurelien.mordret at gmail.com
Mon Oct 20 15:45:50 UTC 2014


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.

-- 

aurelien.mordret at gmail.com
Mobile: 0033 6 67 51 53 56


More information about the MSNoise mailing list