The PJOURNAL table captures records as posting
occurs in Microsoft Dynamics GP. This
table can grow to be very large depending on posting volume. The Microsoft Dynamics GP installation
creates a SQL Server Agent Job to truncate the PJOURNAL table in each
company. Verify the SQL Server Agent
service is running in the SQL Server Management Studio. Expand SQL Server Agent in the SQL Server
Management Studio and verify the "Remove Posted PJOURNALs From All
Companies" job exists and is enabled under the Jobs folder. By
default, the table is cleared every 30 minutes.
If the "Remove Posted PJOURNALs From All Companies" job does
not exist, execute the PJJOB.SQL script in the SQL Server Management Studio to
create the jobs.
The PJJOB.SQL script
can be found in the Microsoft Dynamics\GP\SQL\Util folder.
1 comment:
Nice blog post If you are searching for the qualityMicrosoft Dynamic Jobs than, DFSM Recruitment is known as the best Microsoft Dynamics Recruiter and recruit Microsoft Dynamics 365, CRM, SharePoint, Office 365 clients
Post a Comment