DB-Entries in "job" table

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

DB-Entries in "job" table

Masopust, Christian
Hi all,
 
I'm currently planning to create some procedures to create "management-statistic" pages with BIRT
for our Bacula backup.  I've now done a short investigation what can be found for that purpose within
the existing Bacula database and have seen that the job table seems to contain all the jobs since
I've set up Bacula here.
 
So, my questions:
- will the job table be "pruned" sometime by bacula-dir?
- will dbcheck "Eliminate orphaned Job records" clean the job table?
 
Thanks a lot,
Christian

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
Reply | Threaded
Open this post in threaded view
|

Re: DB-Entries in "job" table

Radosław Korzeniewski
Hello,

2013/9/19 Masopust, Christian <[hidden email]>
Hi all,
 
I'm currently planning to create some procedures to create "management-statistic" pages with BIRT
for our Bacula backup.  I've now done a short investigation what can be found for that purpose within
the existing Bacula database and have seen that the job table seems to contain all the jobs since
I've set up Bacula here.
 
So, my questions:
- will the job table be "pruned" sometime by bacula-dir?

Yes. Check your Job Retention parameter.
 
- will dbcheck "Eliminate orphaned Job records" clean the job table?
 

Yes.

best regards
--
Radosław Korzeniewski
[hidden email]

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
Reply | Threaded
Open this post in threaded view
|

Re: DB-Entries in "job" table

Masopust, Christian
Hi Radoslav,
 
thanks for your answer, but I'm in doubt whether that's correct.  My longest "job retention" is set
to 1 month and I have many jobs in the database that are much older then 1 month.
 
I also tried to run the "eliminate orphaned job records" and none of these old jobs had been
eliminated...
 
br,
christian


Von: Radosław Korzeniewski [mailto:[hidden email]]
Gesendet: Freitag, 20. September 2013 09:51
An: Masopust, Christian
Cc: [hidden email]
Betreff: Re: [Bacula-devel] DB-Entries in "job" table

Hello,

2013/9/19 Masopust, Christian <[hidden email]>
Hi all,
 
I'm currently planning to create some procedures to create "management-statistic" pages with BIRT
for our Bacula backup.  I've now done a short investigation what can be found for that purpose within
the existing Bacula database and have seen that the job table seems to contain all the jobs since
I've set up Bacula here.
 
So, my questions:
- will the job table be "pruned" sometime by bacula-dir?

Yes. Check your Job Retention parameter.
 
- will dbcheck "Eliminate orphaned Job records" clean the job table?
 

Yes.

best regards
--
Radosław Korzeniewski
[hidden email]

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
Reply | Threaded
Open this post in threaded view
|

Re: DB-Entries in "job" table

Radosław Korzeniewski
Hello,

2013/9/20 Masopust, Christian <[hidden email]>
Hi Radoslav,
 
thanks for your answer, but I'm in doubt whether that's correct.  My longest "job retention" is set
to 1 month and I have many jobs in the database that are much older then 1 month.

Check AutoPrune job parameter. Automatic pruning is performed at the end of the job. So when you disable a job its records will bot be pruned.

btw. please, avoid topposting. thanks.

best regards
--
Radosław Korzeniewski
[hidden email]

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
Reply | Threaded
Open this post in threaded view
|

Re: DB-Entries in "job" table

Kern Sibbald
In reply to this post by Masopust, Christian
On 09/19/2013 04:40 PM, Masopust, Christian wrote:
Hi all,
 
I'm currently planning to create some procedures to create "management-statistic" pages with BIRT
for our Bacula backup.  I've now done a short investigation what can be found for that purpose within
the existing Bacula database and have seen that the job table seems to contain all the jobs since
I've set up Bacula here.
 
So, my questions:
- will the job table be "pruned" sometime by bacula-dir?
Yes, either when the Job Retention Period runs out AND you run another job of the
same name, or when the Volume is pruned.
- will dbcheck "Eliminate orphaned Job records" clean the job table?
I am not sure, since there the Job is the "main" record.  I don't use
dbcheck very often, so I forgot the options.

Kern
 
Thanks a lot,
Christian


------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk


_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel


------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/bacula-devel