The Enterprise Scheduler is designed to provide real-time integration between the Schedule and Service Calls and Projects. For example, when a new Service Call is created/updated or a Project is created/updated, it is immediately reflected in the Schedule. This real-time integration is accomplished via SQL Server triggers on the SVC00200 (Service Call Master) table and the PA01301 table (Project Budget Master).
For customers who are performing mass imports and wish to defer the real-time integration with the Schedule to a later batch job, a SQL Stored Procedure is installed with the Enterprise Scheduler that can be run to perform this function. The SQL commands below can be executed through SQL Management Studio to accomplish this requirement. In the example, we are using the Dynamics Company TWO. You would replace ‘TWO’ with your Dynamics Company SQL database name.
BEFORE performing the mass import, the following step should be performed:
1) Disable SQL triggers on the SVC00200 table and PA01301 table;
SQL Command to disable the appropriate SQL triggers
USE TWO
GO
DISABLE TRIGGER SCH_PA01301_InsertSch_TR ON PA01301
GO
DISABLE TRIGGER SCH_SVC00200_InsertSch_TR ON SVC00200
GO
AFTER performing the mass import, the following steps should be performed:
2) Synchronize any newly added or updated Service Calls and Projects;
SQL Command to synchronize Service Calls and Projects
USE TWO
GO
EXEC SCH_Schedule_Reseed
GO
3) Re-enable SQL triggers on the SVC00200 table and PA01301 table;
SQL Command to enable the appropriate SQL triggers
USE TWO
GO
ENABLE TRIGGER SCH_PA01301_InsertSch_TR ON PA01301
GO
ENABLE TRIGGER SCH_SVC00200_InsertSch_TR ON SVC00200
GO
Posted in Enterprise Scheduler
