News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) PRINTJOBHEADER and PRI...

Microsoft Dynamics AX (Archived)

PRINTJOBHEADER and PRINTJOBPAGES - large amount of data

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello all,

We have a customer that runs Axapta 3.0 with Oracle. The database is getting rather big, and we have discovered that the table PRINTJOBPAGES contains a large amount of data (several gigabytes). I know there are a relation between PRINTJOBHEADER and PRINTJOBPAGES and that they are system tables used for the print archive. But part from that I dont see much information about them in the documentation.

My question is if it is possible to truncate these tables to free up data in the tablespaces? What could be the possible loss of doing so?

Kind regards

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: PRINTJOBHEADER and PRINTJOBPAGES - large amount of data

Thank you for the answer!
Verified answer

André Arnaud de Cal... 291,735 Super User 2024 Season 2 on at

Like (0)

Report

RE: PRINTJOBHEADER and PRINTJOBPAGES - large amount of data

Hi,

These tables indeed contains records for a print archive. It could possibly contain any report. Sometimes it is used to store an archive of sent invoices.

It is possible to truncate to free up some space, but first check the contents and the requirements for having these as a backup.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans