Print ''
Print '----------------------------------------------------'
Print ' Script for JobMgr:'
Print ' FirstRevision: V2.0.0   22.03.2006'
Print ' CurrRevision : V2.1.1   29.11.2012'
Print ' Autor        : J.Feuerstein / N.Zimmert'
Print ' '
Print '----------------------------------------------------'
GO

use [#DB_N#]
GO


  -- Setzt fuer Datasets der PGruppe 07 den Status auf RUN
  Print 'Process:ProcStateCol07'
  UPDATE Objects_tbl
         SET ProcStateCol07 = 'RUN'
    where (not ProcStateCol07 like 'X%')
          and ObjectClass = 'DS'
   --      and ObjectCliName in ('@DB/MC-AUTO.2DZ01.B2NQT/----/master/MC-AUTO','@DB/MC-AUTO.MAMAA.B2NQG/AA--/master/MC-AUTO')

  Print '|-> DONE ProcStateCol07'
  go



Print ''
Print '---------------------------------------------------------'
Print ' JobMgr_03_Objects_SET_ProcState07_To_N.sql Script executed'
Print '---------------------------------------------------------'
GO