[mythtv-users] Delayed User Job

[Chris Pinkham]

* On Sat Mar 03, 2007 at 01:51:26AM -0500, f-myth-users at media.mit.edu wrote:
> See http://cvs.mythtv.org/trac/changeset/12917; cpinkham has obviously
> been following this thread and just checked in some infrastructure
> (but not a complete solution yet).

You never know where I'll popup at.

For the archives, with SVN trunk starting at 12917, you'll be able to make
a simple User Job script that contains this:

----------------------------------------------
#!/bin/sh

echo "INSERT INTO jobqueue (chanid, starttime, inserttime, type, status, \
          statustime, schedruntime, hostname, args, comment, flags) \
        VALUES \
          ($1, $2, now(), 1, 1, now(), DATE_ADD(now(), INTERVAL '7' day), \
          '', '', '', 0);" \
    | mysql -u mythuser -h mythdb -pmythpw mythconverg
----------------------------------------------

Then you'd setup a User Job to run that as:

/path/to/my/schedule_future_transcode_script.sh %CHANID% %STARTTIME%

So we use a User Job to schedule a future mythtranscode job. :)

Type 1 is a transcode job, type 2 is commercial flagging.  Status 1 is
'queued'.

--
Chris