Job to continue to run, even if 1 or more vproc's in it fail

Answered

Follow

1

Sjors Takes

• May 31, 2021 06:19

As a data solution architect, I want my job to continue to run, even if 1 or more vproc's in it fail, so that the impact of a failing vproc is limited to a small area.

Alternatively, perhaps it's an idea to schedule the running of vprocs independently, instead of calling them from a job.

• Comment actions Permalink

  Official comment

  

  Matthias Korn

  • June 03, 2021 12:52

  Hi Sjors, 

  would it work for you to have exception handling around the procedures? Here's your code.

  -- This procedure throws an exception for test reasons
  create virtual procedure views.throwError (
  ) as
  begin
     RAISE SQLEXCEPTION 'this is bad' ;
  end;;
  
  -- This could be your sql job definition, we are catching the exception, but not doing anything with it. It would be possible to do logging in the handling part (EXCEPTION E begin ... end)
  begin
     begin
        call "views.throwError" (
        ) ;
        EXCEPTION e
     end
     begin
         call "views.throwError" (
         ) ;
         EXCEPTION e
     end
  end;;

• 0

  Comment actions Permalink

  

  Sjors Takes

  • June 08, 2021 06:05

  That would help indeed, we’re going to implement this. Thanks!

Please sign in to leave a comment.