On Nov 28, 2007 2:14 PM, Jason Joines <[EMAIL PROTECTED]> wrote: > I have several jobs listed with a status of R but trying to cancel > them fails. > > * list jobs > <snip></snip> > | 181 | BackupCatalog | 2007-11-28 00:20:44 | B | F | > 0 | 0 | R | > | 182 | mdc4daily | 2007-11-28 12:42:51 | B | F | > 301,416 | 2,537,166,792 | T | > +-------+-----------------+---------------------+------+-------+----------+----------------+-----------+ > *cancel jobid=181 > JobId 181 is not running. Use Job name to cancel inactive jobs. > *cancel jobname=BackupCatalog > No Jobs running. > * > > The oldest job is > | 17 | oridaily | 2007-11-12 12:07:04 | B | F | > 0 | 0 | R | > and there are several others. How do I get rid of the old jobs with a > status of "R"? >
I am not sure if this is the correct solution but I executed this command on my postgresql database and it cleared the dozens old running jobs from my database: UPDATE public.job set jobstatus='E' WHERE jobstatus = 'R'; The syntax may be different if you have a different database. Also, MAKE SURE that no jobs are actually running when you do this... John ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
