When you use Microsoft Dynamics GP together with Microsoft SQL Server Express Edition, Microsoft Dynamics GP creates a default job to truncate the PJOURNAL table for each company database. The PJOURNAL table stores temporary records that are related to posting. Because the SQL Server Agent service is not available, you must use Windows Task Scheduler to schedule these jobs when you use SQL Server Express Edition.
To create a batch file to schedule a default job by using Windows Task Scheduler, follow these steps:
- In Notepate, paste the following code:Note The SERVERNAME placeholder represents the name of your instance of SQL Server. The DBNAME placeholder represents your company database name.
OSQL -S <SERVERNAME> -E -q "exit(DELETE <DBNAME>..PJOURNAL)"
- If you have multiple company databases, you must create a delete statement for each company. Then, you must add this delete statement to the Notepad file that you created in step 1. Or, you can create a separate batch file for each company.
- Click File, click Save, and then save the file as "PJOURNAL.bat".
- On the computer that is running Microsoft SQL Server Express, click
Start, point to All Programs, point to
Accessories, point to System Tools, and then click Scheduled Tasks.
- Double-click Add Scheduled Task.
- In the Scheduled Task Wizard, click
- Click Browse, click the PJOURNAL.bat file that you created in step 4, and then click
- Type PJOURNAL for the name of the task, and then click Daily. Then, click
- Specify information for a schedule to run the Task. We recommend that you run this at least one time every day. Then, click Next.
- In the Enter the user name field and in the Enter the password field, type a username and a password. Then, click Next.
- Click Finish.
Article ID: 958368 - Last Review: Jul 14, 2012 - Revision: 1