Summary

When you create a job using the "Run a SQL Server job" wizard, the job will fail if the computer on which adTempus is running does not have the SQL Server client tools installed.

The log for the job will have an error message similar to the following:

Failed to create SQL DMO object: ActiveX component can't create object (429)" 

This error occurs because the script that adTempus generates to run the job uses the SQL DMO component distributed with SQL Server. If that component is not on the computer, the script fails.

Workaround

To resolve this problem you can either install the SQL Server client components on the adTempus server (using your own SQL Server installation media) or download and register the necessary component.

Status

Beginning with adTempus 3.0, the SQL Server Job Wizard has been replaced by the new SQL Server Job Task, which does not require that SQL DMO be installed locally.