You created, saved, and ran your first transformation. Now, you will build a simple job. Use jobs to execute one or more transformations, retrieve files from a Web server, place files in a target directory, and more. Additionally, you can schedule jobs to run on specified dates and times. The section called Get Started with DI contains a "real world" exercise for building jobs.
- In the Spoon menubar, go to File > New > Job. Alternatively click (New) in the toolbar.
- Click the Design tab. The nodes that contain job entries appear.
- Expand the General node and select the Start job entry.
- Drag the Start job entry to the workspace (canvas) on the right.
The Start job entry defines where the execution will begin.
- Expand the General node, select and drag a Transformation job entry on to the workspace.
- Use a hop to connect the Start job entry to the Transformation job entry.
- Double-click on the Transformation job entry to open its properties dialog box.
- Under Transformation specification, click Specify by name and directory.
- Click (Browse) to locate your transformation in the solution repository.
- In the Select repository object view, expand the directories. Locate First Transformation and click OK. The name of the transformation and its location appear next to the Specify by name and directory option.
- Under Transformation specification, click OK.
- Save your job; call it First Job. Steps used to save a job are nearly identical to saving a transformation. Provide a meaningful comment when saving your job. See Saving Your Transformation.
- Click (Run Job) in the toolbar. When the Execute a Job dialog box appears, choose Local Execution and click Launch.
The Execution Results panel opens displaying the job metrics and log information for the job execution.