The SQL Server Job task allows you to execute a SQL Server Agent job (a job defined within SQL Server) from adTempus.
This can be useful if you need to incorporate a SQL Server Agent job into a processing flow that is otherwise managed by adTempus. For example, you may want adTempus to execute a sequence like this:
Run a program that loads data into a SQL Server database.
Start a SQL Server job that processes the new data, and wait for that job to complete.
Run a program that produces reports based on the new data.
The SQL Server Job Task allows you to do this without the need to write your own program or database script to start and monitor the SQL Server job.
Responses can be executed based on the results of the SQL Server job.
See Also