SQL Server Agent
When you install Microsoft Dynamics GP on the server, an automated database
maintenance job is created. SQL Server Agent is used to run automated jobs.
Be sure that the SQL Server Agent service is set up to start automatically with the operating system if you are using Microsoft SQL Server. In SQL Server Service Manager, select SQL Server Agent from the list of services and mark the Auto-start service when OS starts option.
Jobs are customizable, and you can select how frequently they should be completed.
You may want certain jobs to run every half hour, while others should run once at night. For more information on scheduling jobs, refer to Microsoft SQL Server Books Online.
Microsoft SQL Server 2005 Express doesn’t include SQL Server Agent. Refer to
Support Hot Topic on CustomerSource https://mbs.microsoft.com/ customersource for more information about scheduling a backup.
Enabling Delete PJournal job The Delete PJournal job is created during the installation of Microsoft Dynamics GP.
By enabling the Delete PJournal job, the speed of the posting process is increased.
To enable Delete PJournal job using Enterprise Manager:
1. Open SQL Server Enterprise Manager.
(Start >> Programs >> Microsoft SQL Server >> Enterprise Manager)
2. Expand Microsoft SQL Server, expand SQL Server Group, and expand the instance of SQL Server used for GP.
3. Expand Management, expand SQL Server Agent, and click Jobs.
4. Right-click on Remove Posted PJournals for your company database and click
Properties to open the Properties window.
5. Unmark and mark the Enable option.
6. Click Apply and then click OK
When you install Microsoft Dynamics GP on the server, an automated database
maintenance job is created. SQL Server Agent is used to run automated jobs.
Be sure that the SQL Server Agent service is set up to start automatically with the operating system if you are using Microsoft SQL Server. In SQL Server Service Manager, select SQL Server Agent from the list of services and mark the Auto-start service when OS starts option.
Jobs are customizable, and you can select how frequently they should be completed.
You may want certain jobs to run every half hour, while others should run once at night. For more information on scheduling jobs, refer to Microsoft SQL Server Books Online.
Microsoft SQL Server 2005 Express doesn’t include SQL Server Agent. Refer to
Support Hot Topic on CustomerSource https://mbs.microsoft.com/ customersource for more information about scheduling a backup.
Enabling Delete PJournal job The Delete PJournal job is created during the installation of Microsoft Dynamics GP.
By enabling the Delete PJournal job, the speed of the posting process is increased.
To enable Delete PJournal job using Enterprise Manager:
1. Open SQL Server Enterprise Manager.
(Start >> Programs >> Microsoft SQL Server >> Enterprise Manager)
2. Expand Microsoft SQL Server, expand SQL Server Group, and expand the instance of SQL Server used for GP.
3. Expand Management, expand SQL Server Agent, and click Jobs.
4. Right-click on Remove Posted PJournals for your company database and click
Properties to open the Properties window.
5. Unmark and mark the Enable option.
6. Click Apply and then click OK
To enable Delete PJournal job using SQL Server
Management Studio:
1. Open SQL Server Management Studio.
(Start >> Programs >> Microsoft SQL Server 2005 >> SQL Server Management
Studio)
2. Log in to Microsoft SQL Server 2005.
3. Expand SQL Server Agent, and click Jobs.
4. Right-click on Remove Posted PJournals for your company database and click
Properties to open the Properties window.
5. Unmark and mark the Enable option.
6. Click Apply and then click OK.
No comments:
Post a Comment