[mythtv-users] Job queue remove old job

[Michael T. Dean]

On 01/18/2020 11:26 AM, John Pilkington wrote:
> On 18/01/2020 15:57, Tom Bishop wrote:
>> Had some stability problems with a new build, which I think I have 
>> sorted now. The one issue I see is on mythweb status page it shows an 
>> old job processing (from Jan 1) which I know is left over and not 
>> processing.  What is the easiest way to clean the old job out, thanks.
>>
>
> I had a long list in the frontend status page, going back several 
> years.  I don't often use user jobs.  Searches suggested direct 
> modification of the DB:
>
> MariaDB [mythconverg]> truncate table jobqueue ;
>
> and I haven't seen problems since.  Is there a safer way?


2 easiest ways (when they work): 
https://lists.gt.net/mythtv/users/416263#416263
Best way/always works: https://lists.gt.net/mythtv/users/608195#608195

Mike