Re: Job expiry based on start date/time of job, or completion date/time of job?
Martin Simmons <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Message-ID | <[email protected]> |
Yes, job pruning is based on the JobTDate, which is in seconds since January 1, 1970. However, JobTDate is just EndTime in different units, not the date should expire. __Martin >>>>> On Wed, 23 Jul 2025 17:09:19 -0400, John Lockard said: > > I'm pretty sure I've math'd my maths and SQL'd my SQLs correctly. I wanted > to be sure that job retention was based on the date/time the job > completed rather than when it started. > > I did this (PostgreSQL DB if that matters): > SELECT JobId, Name, JobTDate, StartTime, EndTime, > TIMESTAMP WITH TIMEZONE 'epoch' + JobTDate * interval '1 second' as > JobExpires > FROM Job LIMIT 40; > > Did I understand the assignment and materials correctly? I think so, I > just want to be sure. > > Thanks, > -John > > -- > -- > - Adaptability -- Analytical --- Ideation ---- Input ----- Belief - > ------------------------------------------------------------------- > John M. Lockard | U of Michigan - School of Information > Unix Sys Admin | Suite 205 | 309 Maynard Street > [email protected] | Ann Arbor, MI 48104-2211 > www.umich.edu/~jlockard <http://www.umich.edu/%7Ejlockard> | > 734-615-8776 | 734-763-9677 FAX > ------------------------------------------------------------------- > - The University of Michigan will never ask you for your password - >