How to manually set the jobstatus of a job

[pnchowdary]

Hi Guys,

I have a requirement where I need to abort the following job based on a value written to a file using writeu in a routine, in the current job. To achieve this, I need to manually set the Jobstatus of the current job to aborted, so that my next job in the sequence does not get kicked off.

Code: Select all

Job1 -----> Job2 -----> Job3

Based on the value written to a file in Job1, I need to manually set the Jobstatus of Job1 to Aborted, so that Job2 does not get kicked off

Any help would be greatly appreciated.

[ukyrvd]

Here is an idea

After Job 1 insert a script and return a value to indicate continue/stop.

Use the script to check the value you are looking for!!

[pnchowdary]

Hi Ukyrd,

return a value to indicate continue/stop.

what value would you return and how would it stop the next job in the sequence from executing?

Thanks for your reponse.

[chulett]

I need to manually set the Jobstatus of the current job to aborted

You can't manually set it, so put that approach out of your head.

What you can do is build a routine to read the file which you can execute via the Routine Activity stage between the two jobs. Abort the routine (ie, call DSLogFatal) if you don't like what it reads. Triggers handle the rest.

Why not just do the abort in the original routine?

[pnchowdary]

Hi Craig,

Thanks for the quick reply. I will try to implement your solution.

[ray.wurlod]

Try to avoid aborting jobs.

You can still exert total control over the sequence using specific values written to files (as you propose), without the need to abort. Use custom triggers and/or Nested Condition activities to control the flow of execution.

[pnchowdary]

Thanks ray, I will sure keep that in mind.
:D