web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Remove Posted PJOURNALs
Microsoft Dynamics GP (Archived)

Remove Posted PJOURNALs

(0) ShareShare
ReportReport
Posted on by Olaf Laos 1,890

Within SQL Server there is the "Remove Posted PJOURNALs From All Companies" job that runs under the SQL Server Agent.

I notice on systems where the customer has transferred Dynamics to a newer server for example, that this agent job does not exist.

a) If it isn't there, will this eventually cause performance or posting problems in Dynamics GP?

b) Is there a quick way to create this job - or perhaps a script that should be run?

c) What's the real purpose to this job being there in the first place?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Remove Posted PJOURNALs

    Your answers are all here

    support.microsoft.com/.../898982

    Cheers!

    Sanjay

  • Peggy Aitken Profile Picture
    Peggy Aitken 90 on at
    Remove Posted PJOURNALs
    I am having a problem with the PJournal.  Several months ago, IT did move GP 2016 to a new server without doing an install.  We were told by support that a MS Dynamics GP "Repair" would load the job.  However, we rocked along for roughly 3 months without a problem only to crash with the same PJOURNAL error today.  I'm attaching all of the screen prints.  I just read the following statement in the doc referenced in this thread https://learn.microsoft.com/en-US/troubleshoot/dynamics/gp/experience-slow-performance
     
    • A PJOURNAL job is also created when you install Microsoft Business Solutions - Great Plains 7.5 and Microsoft Business Solutions - Great Plains 8.0. The PJOURNAL job must be turned on manually for the job to manage the PJOURNAL table so that the table does not grow larger and affect performance.
    IF I was supposed to manually turn on the job, please tell me how to do that.  I can't find anything anywhere.
     
    THANK YOU!!!
     
     
     
     
     
  • Suggested answer
    Joseph Markovich Profile Picture
    Joseph Markovich 3,976 on at
    Remove Posted PJOURNALs
    Hi Peggy-
     
    Typically when I have to upgrade SQL Server and it requires moving all of the GP databases to this new server, one of the steps I have always done is to save the job as a SQL script in SQL Server Management Studio and then run those scripts on the new server to get them created again.
     
    To turn on the job, you'll have to use SQL Server Management Studio, connect to your SQL Server, expand SQL Server Agent, expand Jobs, find the "Remove Posted PJOURNALs From All Companies" job, right click on it and select Enable.
     
    I hope this helps.
     
    Joe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans