2 Replies Latest reply on Dec 27, 2013 7:03 AM by Bernard Affleck

    Programmatically determine the status of a batch job run

      Hi

       

      I want to report on the status of a batch job and it's childrem. the only call i can see is

       

      JobRun showBatchJobRunStatusByRunKey

       

      which produces output as at the bottom of the post:

       

      while I can fire up my parsing skills to concatenate different lines this seems like a headache.

       

      Also the Satus only identifies "COMPLETE" rather tha success or failure.

       

      Is there a more friendly interface?

       

      Alternatively I could review the deifition of the batch file if there were an interface - but there only appear to be BatchJob: add and remove interfaces. no reporting of the child jobs.

       

       

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",Success JobRun getEndTimeByRunKey DBKey:SJobRunModelKeyImpl:6739229-57366897

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",JobResultEndTime = [Thu Dec 19 14:18:40 GMT 2013]

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",[

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",-------------------------------------------------------------------------------------------

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|Name      |Start Time         |Status  |Progress|Sub-Job    |Sub-Job Start Time |Sub-Job |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |           |                   |Status  |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",-------------------------------------------------------------------------------------------

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|J_BATCH_IN|2013/12/19 14:15:59|COMPLETE|4/10 job|J_BATCH_STO|2013/12/19 14:18:03|COMPLETE|

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|TERNAL_RUN|                   |        |s       |P_ALL_yoot-|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|_ALL_yoot-|                   |        |        |simon01    |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|simon01_00|                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|0.000121_D|                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|ummy_2013_|                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|12_19-14_0|                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|1_19_CIPE_|                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|Test_NBI  |                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |J_NSH_APP_U|2013/12/19 14:16:00|COMPLETE|

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |SER_CHECK_y|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |oot-simon01|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |           |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |J_BATCH_PRE|2013/12/19 14:16:43|COMPLETE|

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |_CHECK_ALL_|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |yoot-simon0|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |1          |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |J_BATCH_Dum|2013/12/19 14:17:21|COMPLETE|

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |my_COPY_INS|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |TALL_FILES_|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |000.000121_|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |yoot-simon0|                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",|          |                   |        |        |1          |                   |        |

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",-------------------------------------------------------------------------------------------

      "Run at Dec 19, 2013 2:18:40 PM",Info,"Dec 19, 2013 2:19:13 PM",]

       

       

      Any assistance appreciated