There is no other related data for these jobs.

I made a mistake though: you need

delete from job where type in ('R') ...

to delete restore jobs.  Type 'V' is verify and type 'D' is admin.

__Martin


>>>>> On Wed, 12 Nov 2008 10:47:11 +0800, Quanzhong Zhang said:
> 
> Hello Martin,
> 
> Thank you very much for your replay!
> But are you sure there are no related data in other table for this data?
> 
> Best Regards,
> Zhang QZ
> 
> 
> -----Original Message-----
> From: Martin Simmons [mailto:martin AT lispworks DOT com] 
> Sent: Tuesday, November 11, 2008 6:57 PM
> To: Quanzhong Zhang
> Cc: bacula-users AT lists.sourceforge DOT net
> Subject: Re: [Bacula-users] How to clear the restore job history
> 
>>>>> On Tue, 11 Nov 2008 09:28:28 +0800, Quanzhong Zhang said:
> > 
> > Hello,
> > 
> > I found there are many restore job history in the table "Job", and can
> > not find out the way for clear it.
> > Could you kindly give me help?
> 
> Bacula never deletes them.
> 
> I run the following SQL once a week (on PostgreSQL) to delete those
> older than
> 2 months:
> 
> delete from job where type in ('V', 'D') and starttime < now()-interval
> '2 months';
> 
> __Martin
> 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users