9 Replies Latest reply: Oct 31, 2012 12:49 AM by Deepak Mallick RSS

    How-To:Classify different jobs that were scheduled on a particular date  under respective time with its Status.

      JobDescriptionJobSequenceRunDateExpectedStartTimeJobStatus
      Enlighta Load19-Oct-1210/19/12 8:00COMPLETED ONTIME
      Enlighta Sync19-Oct-1210/19/12 10:05START DELAY RUNNING
      Enlighta Validation19-Oct-1210/19/12 13:20NOT STARTED
      Prism Load19-Oct-1210/19/12 8:00COMPLETED WITH DELAY
      Prism Sync19-Oct-1210/19/12 8:00COMPLETED ONTIME
      Prism Validation19-Oct-1210/19/12 18:05NOT STARTED
      Enlighta Load20-Oct-1210/20/12 8:00NOT STARTED
      Enlighta Sync20-Oct-1210/20/12 10:05NOT STARTED
      Enlighta Validation20-Oct-1210/20/12 13:20NOT STARTED
      Prism Load20-Oct-1210/20/12 8:00NOT STARTED
      Prism Sync20-Oct-1210/20/12 8:00NOT STARTED
      Prism Validation20-Oct-1210/20/12 18:05NOT STARTED

       

      I have the above table .... When a user select a particular JobSequenceRunDate,say example-19-Oct-12 then based on the selection all my JobDescription should be classified under the respective Hours slot with JobStatus that were scheduled to run on that date.

       

      Output:

      Hours slotJobDescriptionJobDescriptionJobDescription
      23:00
      0:00
      1:00
      2:00
      3:00
      4:00
      5:00
      6:00
      7:00
      8:00

      Enlighta Load

      COMPLETED ONTIME

      Prism Load

      COMPLETED WITH DELAY

      Prism Sync

      COMPLETED ONTIME

      9:00
      10:00

      Enlighta Sync

      START DELAY RUNNING

      11:00
      12:00
      13:00

      Enlighta Validation

      NOT STARTED

      14:00
      15:00
      16:00
      17:00
      18:00

      Prism Validation

      NOT STARTED

      19:00
      20:00
      21:00
      22:00

       

      Thanks in Advance...

       

      Message was edited by: deepak_mallick Done some changes as there was a horizontal scollbar coming....Hope its clear to everyone...Waiting for ur valuable responses