This article describes how to create a batch file to
schedule a job by using Windows Task Scheduler when you use Microsoft Dynamics
a computer that is running Microsoft SQL Server 2005 Express Edition or Microsoft SQL Server 2008
If you are running SQL Server 2005 Express
Edition or SQL Server 2008 Express
Edition on the computer, the SQL Server Agent service is unavailable.
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
OSQL -S <SERVERNAME> -E -q "exit(DELETE <DBNAME>..PJOURNAL)"
- If you have multiple company databases, you must create
a delete statement for
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".
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
- 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
schedule to run the Task. We recommend that you run this at least one
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.
Microsoft Dynamics GP 9.0 is not supported on SQL Server 2008. However, Microsoft Dynamics GP 9.0 is supported on SQL Server 2005.
Article ID: 958368 - Last Review: July 14, 2012 - Revision: 3.0
- Microsoft Dynamics GP 10.0
- Microsoft Dynamics GP 9.0
- System Manager
|kbexpertiseadvanced kbexpertiseinter kbhowto kbinfo kbmbsmigrate kbexpertisebeginner KB958368|