[mythtv-users] Is there a way (via Myth or mysql) to list recording rules with an active user job?

[Ian Evans]

On Thu, Nov 28, 2013 at 10:48 PM, Stephen Worthington <
stephen_agent at jsw.gen.nz> wrote:

> On Thu, 28 Nov 2013 15:40:48 -0500, you wrote:
>
> >A while back I had a user job that was run on every recording. I've since
> >changed that user job slot to be used by mythvidexport.py .
> >
> >However...
> >
> >Some of my recording rules (some of which may only be triggered once a
> >year) have the user job (#3) still active, but of course know it's trying
> >to automatically run mythvidexport.py on them...which is something I don't
> >want.
> >
> >Is there a way to list all the recording rules which have an active User
> >Job #3 so I can then go into those rules and turn it off?
> >
> >Thanks.
>
> WARNING: Backup your database before messing around with it!  If you
> do not already know how to do that and to restore it again, you
> probably should not be using SQL commands.
>
> This SQL should show all the jobs with user job 3 enabled:
>
>   select recordid,type,chanid,starttime,title,autouserjob3 from record
> where autouserjob3!=0;
>
> And this should turn off all user job 3s:
>
>   update record set autouserjob3=0 where autouserjob3!=0;


Thanks. Worked like a charm.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131128/5fa58d93/attachment.html>