<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Thu, Nov 28, 2013 at 10:48 PM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Thu, 28 Nov 2013 15:40:48 -0500, you wrote:<br>
<br>
>A while back I had a user job that was run on every recording. I've since<br>
>changed that user job slot to be used by mythvidexport.py .<br>
><br>
>However...<br>
><br>
>Some of my recording rules (some of which may only be triggered once a<br>
>year) have the user job (#3) still active, but of course know it's trying<br>
>to automatically run mythvidexport.py on them...which is something I don't<br>
>want.<br>
><br>
>Is there a way to list all the recording rules which have an active User<br>
>Job #3 so I can then go into those rules and turn it off?<br>
><br>
>Thanks.<br>
<br>
</div></div>WARNING: Backup your database before messing around with it! If you<br>
do not already know how to do that and to restore it again, you<br>
probably should not be using SQL commands.<br>
<br>
This SQL should show all the jobs with user job 3 enabled:<br>
<br>
select recordid,type,chanid,starttime,title,autouserjob3 from record<br>
where autouserjob3!=0;<br>
<br>
And this should turn off all user job 3s:<br>
<br>
update record set autouserjob3=0 where autouserjob3!=0;</blockquote><div><br></div><div>Thanks. Worked like a charm.<br></div></div></div></div>