Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Suggested answer
    Joseph Markovich Profile Picture
    Joseph Markovich 3,900 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
  • Peggy Aitken Profile Picture
    Peggy Aitken 88 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
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remove Posted PJOURNALs

    Your answers are all here

    support.microsoft.com/.../898982

    Cheers!

    Sanjay

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans