Validating Jobs

Objectives

After completing this lesson, you will be able to:

  • Validate jobs

Job Validation

It is advisable to validate jobs when ready for job execution to ensure that there are no errors. It is also possible to select an option to perform this validation automatically when executing jobs.

As a best practice, validate work whilst objects are being built to avoid many warnings and errors at run time.

Validate Current vs Validate All

You'll find two different options to validate as you build.

  • Validate Current : will only validate the current workspace.

    For example, if you are currently displaying the job workspace and the error is in the data flow inside that job, you won't get an error message.

    You would if the job contained a script with an error.

  • Validate All : will validate all the objects in the current workspace and all objects that they contain.

    So, here you would get an error if the data flow in the displayed work flow had an error in the Query transform for example.

    But you would not get an error for the other work flow in the same job and its objects.

You can also automatically validate all jobs before executing them.

Here, let me show you an example :

Log in to track your progress & complete quizzes