Implementation

The implementation steps are the most important section. It consists of code blocks that creates the contents of the job. Typically at least one table and a procedure.
You can right-click on the “Implementation” tree element to add new code blocks. You can use drag-and-drop to position the code elements as they are executed in the order they appear in the interface.

Code elements like create table and view is quite straight forward. The main procedure has some elements that is mandatory and different for each platform, and is covered in a sperate subsection.
The cleanup code is mostly used as part of development, as you can execute code blocks on a spesific database instance. You can choose the database instance in the “Connected to” pulldown menu. “Execute code” will execute this code block on that database instance.
In the case of a create table statement, it can help development to add a drop table statement in the cleanup code, and hook the execute before checkbox. This will allow you to recreate the table until you are happy with the layout. It is not common to keep the cleanup code in these code blocks after development, as this type of functionality is handled by the “Force install” or “Cleanup” checkboxes in normal use.

← Pre implementation / Main procedure SQL Server →