Hi Martin,

Thanks for the reply, glad to know that it's not just me. They're InitCatalog Verify jobs. Going to SQL feels a bit hairy, as we'd have to be careful to cascade the delete to at least the File and Log tables.

As prune (unfortunately) only lets you work on a single client at a time, perhaps the best option is to script them.

Might be best anyway - I'm getting a bit sick of all the emails from various ConsoleRunBeforeJob directives :)

Best,

Mark

On Thu, 5 Nov 2020, Martin Simmons wrote:

You are correct that autoprune doesn't get rid of Verify jobs.

What is the Level of your Verify jobs? I run VolumeToCatalog Verify jobs but
they never have any files listed by "list files jobid=<jobid>" (just the job
record itself) so I don't understand your comment below.

I work around the autoprune issue by running this SQL command via an Admin
job:

delete from job where (type in ('V', 'D')
                      or (type = 'B' and jobbytes = 0 and jobfiles = 0))
                     and starttime < now()-interval '2 months';

It also deletes old Admin jobs and old jobs with no contents.

__Martin


_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to