How to get here
We have some example jobs to make the development easier here.
To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu.
To create a new Task or Alert from scratch, open an existing job in the editor and click “New”.
You will then be prompted with a dialog that lets you fill in the basic details of the new Task or Alert.
Developing your own engine jobs
The editor has a tree structure and the top level has two areas:
Properties this is where the general settings for the job are configured.
Metadata this is metadata the job will set on its own object once installed.
The underlying nodes are:
Internal objects this is a mapping of objects this job creates.
External dependencies are dependencies outside this job, to other tables, functions procedures, or views.
Configuration parameters are the parameters that a user can use to adjust thresholds. We can access the parameter values set here from inside the program code.
Installation variables are used for input variables prompted on job installation.
Pre implementation is used for objects or grants that needs to be implemented, often by another user, before implementation steps.
Implementation is the main step where tables, views, functions and procedures for a job is located.
Post implementation is used for steps after the implementation, such as recompilation of procedures
Upgrade is sets of implementation steps to upgrade from one or multiple versions to the current version
Report is the report available when you click on “Details” in the job menu.