Skip to main content

Using SQL Agent to Run Data Sync Projects

If you prefer to use SQL Server Agent to schedule and run your Data Synchronisation Studio projects you can do so by calling a Run Tool project from SQL Server.

To get started you need to have added your Data Sync projects to a Run Tool project. If you do not know how to do this, please see our Run Tool documentation to help get you started.

Create a New Job​

You then need to create a new job in SQL Agent. SQL Server Agent

Add a new CmdExec Job Step​

Add a CmdExec step to the job and set the Command to Simego.DataSync.Run.exe e.g. C:\Program Files\Simego\Data Synchronisation Studio 6.0\Simego.DataSync.Run.exe

And set the path to your project file e.g. C:\PathToProject\project.dsrun -execute -window:minimize

Add Job Step

info

Data Sync will run under the user context of SQL Agent therefore your SQL Agent service account must have enough privileges to access the resources in your Data Sync projects. ::