dbo.QBM_PScheduleStartJob

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> _paramName1.@event at line 48; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 8.974 characters

Interpretation

Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

HOFireEvent -> _paramName1.@event at line 48
References QBM_PJobCreate*
References QBM_PJobCreate_HOFireEvent*

Typed Edges

references source dbo.QBM_FCVStringToList source text reference
references source dbo.QBM_FGIConfigparmValue source text reference
references source dbo.QBM_FGISessionContext source text reference
references source dbo.QBM_FGISessionErrorRethrow source text reference
references source dbo.QBM_PJobCreate source text reference
references source dbo.QBM_PJobCreate_HOFireEvent source text reference
references source dbo.QBM_PJobCreate_HOFireEvent_B source text reference
references source dbo.QBM_PJournal source text reference
references source dbo.QBM_PProcessCreate source text reference
references source dbo.QBM_PSessionContextSet source text reference
references source dbo.QBM_PSessionErrorAdd source text reference
references source dbo.QBM_FCVStringToList_i source text reference

References

Referenced By

dbo.QBM_ZScheduleStartJob

Complete Source

1CREATE PROCEDURE QBM_PScheduleStartJob(2  @uid_JobAutoStart varchar(38)3)4AS5BEGIN6  SET nocount7    ON8  DECLARE @BasisObjectType nvarchar(255)9  DECLARE @UID_DialogTable varchar(38)10  DECLARE @WhereClause nvarchar(max)11  DECLARE @Name nvarchar(255)12  DECLARE @Event nvarchar(255)13  DECLARE @ScheduleName nvarchar(255)14  DECLARE @MessageString nvarchar(1024)15  DECLARE @GenProcID varchar(38)16  DECLARE @XUser nvarchar(64) = object_name(@@procid)17  DECLARE @StopTimeChar nvarchar(8)18  DECLARE @StartTimeChar nvarchar(8)19  DECLARE @StopTime datetime20  DECLARE @StopTimeFull nvarchar(64)21  DECLARE @jetzt datetime22  DECLARE @ParameterList nvarchar(max)23  DECLARE @p nvarchar(4000)24  DECLARE @v nvarchar(max)25  DECLARE @p4 nvarchar(1024),26  @v4 nvarchar(max),27  @p5 nvarchar(1024),28  @v5 nvarchar(max),29  @p6 nvarchar(1024),30  @v6 nvarchar(max),31  @p7 nvarchar(1024),32  @v7 nvarchar(max),33  @p8 nvarchar(1024),34  @v8 nvarchar(max),35  @p9 nvarchar(1024),36  @v9 nvarchar(max),37  @p10 nvarchar(1024),38  @v10 nvarchar(max),39  @p11 nvarchar(1024),40  @v11 nvarchar(max),41  @p12 nvarchar(1024),42  @v12 nvarchar(max),43  @p13 nvarchar(1024),44  @v13 nvarchar(max),45  @p14 nvarchar(1024),46  @v14 nvarchar(max),47  @p15 nvarchar(1024),48  @v15 nvarchar(max),49  @p16 nvarchar(1024),50  @v16 nvarchar(max),51  @p17 nvarchar(1024),52  @v17 nvarchar(max),53  @p18 nvarchar(1024),54  @v18 nvarchar(max),55  @p19 nvarchar(1024),56  @v19 nvarchar(max),57  @p20 nvarchar(1024),58  @v20 nvarchar(max),59  @p21 nvarchar(1024),60  @v21 nvarchar(max),61  @p22 nvarchar(1024),62  @v22 nvarchar(max),63  @p23 nvarchar(1024),64  @v23 nvarchar(max),65  @p24 nvarchar(1024),66  @v24 nvarchar(max),67  @p25 nvarchar(1024),68  @v25 nvarchar(max),69  @p26 nvarchar(1024),70  @v26 nvarchar(max),71  @p27 nvarchar(1024),72  @v27 nvarchar(max),73  @p28 nvarchar(1024),74  @v28 nvarchar(max),75  @p29 nvarchar(1024),76  @v29 nvarchar(max),77  @p30 nvarchar(1024),78  @v30 nvarchar(max),79  @p31 nvarchar(1024),80  @v31 nvarchar(max)81  DECLARE @DebugLevel char(1) = 'I'82  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')83  DECLARE @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser')84  DECLARE @para QBM_YCursorBuffer85  SET XACT_ABORT OFF86  BEGIN TRY87    SELECT @jetzt = GetUTCDate()88    SELECT89      @Name = j.Name,90      @UID_DialogTable = t.UID_DialogTable,91      @BasisObjectType = t.TableName,92      @WhereClause = j.WhereClause,93      @Event = et.EventName,94      @StopTimeChar = j.StopTime,95      @StartTimeChar = CASE96      WHEN s.StartTime = 'LB:ST' THEN97      ''98    ELSE isnull(s.StartTime,99    '')100    END,101    @ParameterList = j.ParameterList,102    @ScheduleName = isnull(s.Name,103    j.Name)104    FROM JobAutoStart j105      WITH(readpast)106    JOIN QBMEvent et107      WITH(readpast)108      ON et.UID_QBMEvent = j.UID_QBMEvent109    JOIN dialogtable t110      WITH(readpast)111      ON et.UID_DialogTable = t.UID_DialogTable112    LEFT113    OUTER114    JOIN DialogSchedule s115      WITH(readpast)116      ON j.uid_DialogSchedule = s.uid_dialogSchedule117    WHERE118      j.uid_JobAutoStart = @uid_JobAutoStart119    IF isnull(@WhereClause,120    N '') = N ''121    BEGIN122      SELECT @WhereClause = N '1=1'123    END124    IF isnull(@StoptimeChar,125    '') > ' ' AND isnull(@StartTimeChar,126    '') > ' '127    BEGIN128      IF isnumeric(@StoptimeChar) = 1129      BEGIN130        SELECT131          @StopTime = dateadd(hh,132          convert(int, @StoptimeChar),133          @jetzt)134        IF @stoptime = @jetzt135        BEGIN136          SELECT137            @Stoptime = convert(datetime,138            '2200-01-01',139            121)140        END141      END142      ELSE143      BEGIN144        SELECT145          @Stoptime = convert(datetime,146          '2200-01-01',147          121)148      END149    END150    ELSE151    BEGIN152      SELECT153        @Stoptime = convert(datetime,154        '2200-01-01',155        121)156    END157    SELECT158      @StopTimeFull = convert(nvarchar(64),159      @Stoptime,160      121)161    SELECT162      @MessageString = CONCAT('#LDS#Starting job : {0}.|',163      @Name,164      '|')165    EXEC QBM_PJournal @MessageString,166      @@procid,167    'I',168      @DebugLevel169    SELECT @GenProcID = newid()170    EXEC QBM_PSessionContextSet 'GenProcID',171      @GenProcID172    EXEC QBM_PSessionContextSet 'XUser',173      @XUser174    IF '1' = dbo.QBM_FGIConfigparmValue('Common\ProcessState')175    BEGIN176      EXEC QBM_PProcessCreate @GenProcID,177      'QBM_PScheduleStartJob',178        @DisplayName = @ScheduleName179    END180    IF @Stoptime > GetUTCDate()181    BEGIN182      INSERT INTO @para(Int1,183      ContentShort,184      ContentFull)185      SELECT186        s.OrderNumber,187        LEFT(s.Parameter1,188        400),189        s.Parameter2190      FROM dbo.QBM_FCVStringToList_i(@parameterList,191      nchar(7),192      1,193      0,194      N '=') AS s195      SELECT196        @p=null,197        @v=null198      SELECT199        TOP 1 @p = pa.ContentShort,200        @v = pa.ContentFull201      FROM @para pa202      WHERE203        pa.Int1 = 1204      IF @p > ' '205      BEGIN206        SELECT @p4 = N '_paramName2'207        SELECT @v4 = @p208        SELECT @p5 = N '_paramValue2'209        SELECT @v5 = @v210      END211      SELECT212        @p=null,213        @v=null214      SELECT215        TOP 1 @p = pa.ContentShort,216        @v = pa.ContentFull217      FROM @para pa218      WHERE219        pa.Int1 = 2220      IF @p > ' '221      BEGIN222        SELECT @p6 = N '_paramName3'223        SELECT @v6 = @p224        SELECT @p7 = N '_paramValue3'225        SELECT @v7 = @v226      END227      SELECT228        @p=null,229        @v=null230      SELECT231        TOP 1 @p = pa.ContentShort,232        @v = pa.ContentFull233      FROM @para pa234      WHERE235        pa.Int1 = 3236      IF @p > ' '237      BEGIN238        SELECT @p8 = N '_paramName4'239        SELECT @v8 = @p240        SELECT @p9 = N '_paramValue4'241        SELECT @v9 = @v242      END243      SELECT244        @p=null,245        @v=null246      SELECT247        TOP 1 @p = pa.ContentShort,248        @v = pa.ContentFull249      FROM @para pa250      WHERE251        pa.Int1 = 4252      IF @p > ' '253      BEGIN254        SELECT @p10 = N '_paramName5'255        SELECT @v10 = @p256        SELECT @p11 = N '_paramValue5'257        SELECT @v11 = @v258      END259      SELECT260        @p=null,261        @v=null262      SELECT263        TOP 1 @p = pa.ContentShort,264        @v = pa.ContentFull265      FROM @para pa266      WHERE267        pa.Int1 = 5268      IF @p > ' '269      BEGIN270        SELECT @p12 = N '_paramName6'271        SELECT @v12 = @p272        SELECT @p13 = N '_paramValue6'273        SELECT @v13 = @v274      END275      SELECT276        @p=null,277        @v=null278      SELECT279        TOP 1 @p = pa.ContentShort,280        @v = pa.ContentFull281      FROM @para pa282      WHERE283        pa.Int1 = 6284      IF @p > ' '285      BEGIN286        SELECT @p14 = N '_paramName7'287        SELECT @v14 = @p288        SELECT @p15 = N '_paramValue7'289        SELECT @v15 = @v290      END291      SELECT292        @p=null,293        @v=null294      SELECT295        TOP 1 @p = pa.ContentShort,296        @v = pa.ContentFull297      FROM @para pa298      WHERE299        pa.Int1 = 7300      IF @p > ' '301      BEGIN302        SELECT @p16 = N '_paramName8'303        SELECT @v16 = @p304        SELECT @p17 = N '_paramValue8'305        SELECT @v17 = @v306      END307      SELECT308        @p=null,309        @v=null310      SELECT311        TOP 1 @p = pa.ContentShort,312        @v = pa.ContentFull313      FROM @para pa314      WHERE315        pa.Int1 = 8316      IF @p > ' '317      BEGIN318        SELECT @p18 = N '_paramName9'319        SELECT @v18 = @p320        SELECT @p19 = N '_paramValue9'321        SELECT @v19 = @v322      END323      SELECT324        @p=null,325        @v=null326      SELECT327        TOP 1 @p = pa.ContentShort,328        @v = pa.ContentFull329      FROM @para pa330      WHERE331        pa.Int1 = 9332      IF @p > ' '333      BEGIN334        SELECT @p20 = N '_paramName10'335        SELECT @v20 = @p336        SELECT @p21 = N '_paramValue10'337        SELECT @v21 = @v338      END339      SELECT340        @p=null,341        @v=null342      SELECT343        TOP 1 @p = pa.ContentShort,344        @v = pa.ContentFull345      FROM @para pa346      WHERE347        pa.Int1 = 10348      IF @p > ' '349      BEGIN350        SELECT @p22 = N '_paramName11'351        SELECT @v22 = @p352        SELECT @p23 = N '_paramValue11'353        SELECT @v23 = @v354      END355      SELECT356        @p=null,357        @v=null358      SELECT359        TOP 1 @p = pa.ContentShort,360        @v = pa.ContentFull361      FROM @para pa362      WHERE363        pa.Int1 = 11364      IF @p > ' '365      BEGIN366        SELECT @p24 = N '_paramName12'367        SELECT @v24 = @p368        SELECT @p25 = N '_paramValue12'369        SELECT @v25 = @v370      END371      SELECT372        @p=null,373        @v=null374      SELECT375        TOP 1 @p = pa.ContentShort,376        @v = pa.ContentFull377      FROM @para pa378      WHERE379        pa.Int1 = 12380      IF @p > ' '381      BEGIN382        SELECT @p26 = N '_paramName13'383        SELECT @v26 = @p384        SELECT @p27 = N '_paramValue13'385        SELECT @v27 = @v386      END387      SELECT388        @p=null,389        @v=null390      SELECT391        TOP 1 @p = pa.ContentShort,392        @v = pa.ContentFull393      FROM @para pa394      WHERE395        pa.Int1 = 13396      IF @p > ' '397      BEGIN398        SELECT @p28 = N '_paramName14'399        SELECT @v28 = @p400        SELECT @p29 = N '_paramValue14'401        SELECT @v29 = @v402      END403      SELECT404        @p=null,405        @v=null406      SELECT407        TOP 1 @p = pa.ContentShort,408        @v = pa.ContentFull409      FROM @para pa410      WHERE411        pa.Int1 = 14412      IF @p > ' '413      BEGIN414        SELECT @p30 = N '_paramName15'415        SELECT @v30 = @p416        SELECT @p31 = N '_paramValue15'417        SELECT @v31 = @v418      END419      EXEC QBM_PJobCreate_HOFireEvent_B @BasisObjectType,420        @WhereClause,421        @EventName = @event,422        @GenProcID = @GenProcID,423        @AdditionalObjectKeysAffected = DEFAULT,424        @p2 = N '_paramName1',425        @v2 = N 'StopTime',426        @p3 = N '_paramValue1',427        @v3 = @StopTimeFull,428        @p4 = @p4,429        @v4 = @v4,430        @p5 =@p5,431        @v5 = @v5,432        @p6 = @p6,433        @v6 = @v6,434        @p7 = @p7,435        @v7 = @v7,436        @p8 = @p8,437        @v8 = @v8,438        @p9 = @p9,439        @v9 = @v9,440        @p10 = @p10,441        @v10 = @v10,442        @p11 = @p11,443        @v11 = @v11,444        @p12 = @p12,445        @v12 = @v12,446        @p13 = @p13,447        @v13 = @v13,448        @p14 = @p14,449        @v14 = @v14,450        @p15 = @p15,451        @v15 = @v15,452        @p16 = @p16,453        @v16 = @v16,454        @p17 = @p17,455        @v17 = @v17,456        @p18 = @p18,457        @v18 = @v18,458        @p19 = @p19,459        @v19 = @v19,460        @p20 = @p20,461        @v20 = @v20,462        @p21 = @p21,463        @v21 = @v21,464        @p22 = @p22,465        @v22 = @v22,466        @p23 = @p23,467        @v23 = @v23,468        @p24 = @p24,469        @v24 = @v24,470        @p25 = @p25,471        @v25 = @v25,472        @p26 = @p26,473        @v26 = @v26,474        @p27 = @p27,475        @v27 = @v27,476        @p28 = @p28,477        @v28 = @v28,478        @p29 = @p29,479        @v29 = @v29,480        @p30 = @p30,481        @v30 = @v30,482        @p31 = @p31,483        @v31 = @v31,484        @Priority = 12,485        @checkForExisting =1486    END487    ELSE488    BEGIN489      SELECT490        @MessageString = N 'Job ' + @Name + N ' not started, Time exceeded : ' + @StopTimeFull491      EXEC QBM_PJournal @MessageString,492        @@PROCID,493      'W',494        @DebugLevel495    END496  END TRY497  BEGIN CATCH498    EXEC QBM_PSessionErrorAdd DEFAULT499    EXEC QBM_PSessionContextSet 'GenProcID',500      @GenProcID_R501    EXEC QBM_PSessionContextSet 'XUser',502      @XUser_R503    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()504    RAISERROR(@Rethrow,505    18,506    1)507      WITH NOWAIT508  END CATCH509  ende:510  EXEC QBM_PSessionContextSet 'GenProcID',511    @GenProcID_R512  EXEC QBM_PSessionContextSet 'XUser',513    @XUser_R514  RETURN515END

Open raw exported source

1     create   procedure QBM_PScheduleStartJob (@uid_JobAutoStart varchar(38)  ) as begin set nocount on declare @BasisObjectType nvarchar(255) declare2 @UID_DialogTable varchar(38) declare @WhereClause nvarchar(max) declare @Name nvarchar(255) declare @Event nvarchar(255) declare @ScheduleName nvarchar3(255) declare @MessageString nvarchar(1024) declare @GenProcID varchar(38) declare @XUser nvarchar(64) = object_name(@@procid) declare @StopTimeChar nvarchar4(8) declare @StartTimeChar nvarchar(8) declare @StopTime datetime declare @StopTimeFull nvarchar(64)  declare @jetzt datetime   declare @ParameterList 5nvarchar(max) declare @p nvarchar(4000) declare @v nvarchar(max) declare @p4 nvarchar (1024) , @v4 nvarchar (max) , @p5 nvarchar (1024) , @v5 nvarchar 6(max) , @p6 nvarchar (1024) , @v6 nvarchar (max) , @p7 nvarchar (1024) , @v7 nvarchar (max) ,  @p8 nvarchar (1024) , @v8 nvarchar (max) , @p9 nvarchar 7(1024) , @v9 nvarchar (max) , @p10 nvarchar (1024) , @v10 nvarchar (max) ,  @p11 nvarchar (1024) , @v11 nvarchar (max) ,  @p12 nvarchar (1024) , @v12 nvarchar8 (max) , @p13 nvarchar (1024) , @v13 nvarchar (max) , @p14 nvarchar (1024) , @v14 nvarchar (max) , @p15 nvarchar (1024) , @v15 nvarchar (max) , @p16 nvarchar9 (1024) , @v16 nvarchar (max) , @p17 nvarchar (1024) , @v17 nvarchar (max) ,  @p18 nvarchar (1024) , @v18 nvarchar (max) , @p19 nvarchar (1024) , @v19 10nvarchar (max)  , @p20 nvarchar (1024) , @v20 nvarchar (max) , @p21 nvarchar (1024) , @v21 nvarchar (max) , @p22 nvarchar (1024) , @v22 nvarchar (max) 11, @p23 nvarchar (1024) , @v23 nvarchar (max) , @p24 nvarchar (1024) , @v24 nvarchar (max) , @p25 nvarchar (1024) , @v25 nvarchar (max) , @p26 nvarchar 12(1024) , @v26 nvarchar (max) , @p27 nvarchar (1024) , @v27 nvarchar (max) , @p28 nvarchar (1024) , @v28 nvarchar (max) , @p29 nvarchar (1024) , @v29 nvarchar13 (max) , @p30 nvarchar (1024) , @v30 nvarchar (max) , @p31 nvarchar (1024) , @v31 nvarchar (max)  declare @DebugLevel char(1) = 'I' declare @GenProcID_R14 varchar(38) = dbo.QBM_FGISessionContext('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') declare @para QBM_YCursorBuffer SET XACT_ABORT15 OFF BEGIN TRY  select @jetzt = GetUTCDate() select @Name = j.Name, @UID_DialogTable = t.UID_DialogTable, @BasisObjectType = t.TableName, @WhereClause 16= j.WhereClause, @Event = et.EventName, @StopTimeChar = j.StopTime, @StartTimeChar = case when s.StartTime = 'LB:ST' then '' else isnull(s.StartTime, ''17) end, @ParameterList = j.ParameterList, @ScheduleName = isnull(s.Name, j.Name) from JobAutoStart j with (readpast) join QBMEvent et with (readpast) on18 et.UID_QBMEvent = j.UID_QBMEvent join dialogtable t with (readpast) on et.UID_DialogTable = t.UID_DialogTable left outer join DialogSchedule s with (readpast19) on j.uid_DialogSchedule = s.uid_dialogSchedule where j.uid_JobAutoStart = @uid_JobAutoStart  if isnull(@WhereClause, N'') = N'' begin select @WhereClause20 = N'1=1' end  if isnull(@StoptimeChar, '') > ' ' and isnull(@StartTimeChar, '') > ' ' begin if isnumeric(@StoptimeChar) = 1 begin select @StopTime = dateadd21(hh, convert(int, @StoptimeChar), @jetzt)  if @stoptime = @jetzt begin select @Stoptime = convert(datetime, '2200-01-01', 121) end end else begin select22 @Stoptime = convert(datetime, '2200-01-01', 121) end  end else  begin select @Stoptime = convert(datetime, '2200-01-01', 121) end select @StopTimeFull23 = convert(nvarchar(64), @Stoptime, 121)  select @MessageString = concat('#LDS#Starting job : {0}.|' , @Name , '|' ) exec QBM_PJournal @MessageString, 24@@procid, 'I', @DebugLevel    select @GenProcID = newid() exec QBM_PSessionContextSet 'GenProcID', @GenProcID exec QBM_PSessionContextSet 'XUser', @XUser25 if '1' = dbo.QBM_FGIConfigparmValue('Common\ProcessState') begin exec QBM_PProcessCreate @GenProcID, 'QBM_PScheduleStartJob', @DisplayName = @ScheduleName26 end if @Stoptime > GetUTCDate() begin  insert into @para (Int1  , ContentShort  , ContentFull  ) select s.OrderNumber, left(s.Parameter1,400), s.Parameter227 from dbo.QBM_FCVStringToList_i(@parameterList, nchar(7), 1,0, N'=') as s   select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull28 from @para pa where pa.Int1 = 1 if @p > ' '  begin select @p4 = N'_paramName2' select @v4 = @p select @p5 = N'_paramValue2' select @v5 = @v end  select29 @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 2 if @p > ' '  begin select @p6 = N'_paramName3'30 select @v6 = @p select @p7 = N'_paramValue3' select @v7 = @v end  select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from31 @para pa where pa.Int1 = 3 if @p > ' '  begin select @p8 = N'_paramName4' select @v8 = @p select @p9 = N'_paramValue4' select @v9 = @v end  select @p=null32, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 4 if @p > ' '  begin select @p10 = N'_paramName5' select33 @v10 = @p select @p11 = N'_paramValue5' select @v11 = @v end  select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para34 pa where pa.Int1 = 5 if @p > ' '  begin select @p12 = N'_paramName6' select @v12 = @p select @p13 = N'_paramValue6' select @v13 = @v end  select @p=null35, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 6 if @p > ' '  begin select @p14 = N'_paramName7' select36 @v14 = @p select @p15 = N'_paramValue7' select @v15 = @v end  select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para37 pa where pa.Int1 = 7 if @p > ' '  begin select @p16 = N'_paramName8' select @v16 = @p select @p17 = N'_paramValue8' select @v17 = @v end  select @p=null38, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 8 if @p > ' '  begin select @p18 = N'_paramName9' select39 @v18 = @p select @p19 = N'_paramValue9' select @v19 = @v end   select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para40 pa where pa.Int1 = 9 if @p > ' '  begin select @p20 = N'_paramName10' select @v20 = @p select @p21 = N'_paramValue10' select @v21 = @v end  select @p=null41, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 10 if @p > ' '  begin select @p22 = N'_paramName11' select42 @v22 = @p select @p23 = N'_paramValue11' select @v23 = @v end  select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para43 pa where pa.Int1 = 11 if @p > ' '  begin select @p24 = N'_paramName12' select @v24 = @p select @p25 = N'_paramValue12' select @v25 = @v end  select @p=null44, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 12 if @p > ' '  begin select @p26 = N'_paramName13' select45 @v26 = @p select @p27 = N'_paramValue13' select @v27 = @v end  select @p=null, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para46 pa where pa.Int1 = 13 if @p > ' '  begin select @p28 = N'_paramName14' select @v28 = @p select @p29 = N'_paramValue14' select @v29 = @v end  select @p=null47, @v=null select top 1 @p = pa.ContentShort , @v = pa.ContentFull from @para pa where pa.Int1 = 14 if @p > ' '  begin select @p30 = N'_paramName15' select48 @v30 = @p select @p31 = N'_paramValue15' select @v31 = @v end    exec QBM_PJobCreate_HOFireEvent_B @BasisObjectType,  @WhereClause,   @EventName = @event49,   @GenProcID = @GenProcID, @AdditionalObjectKeysAffected = DEFAULT, @p2 = N'_paramName1', @v2 = N'StopTime', @p3 = N'_paramValue1', @v3 = @StopTimeFull50, @p4 = @p4, @v4 = @v4 , @p5 =@p5 , @v5 = @v5 , @p6 = @p6, @v6 = @v6 , @p7 = @p7, @v7 = @v7 , @p8 = @p8, @v8 = @v8 , @p9 = @p9, @v9 = @v9 , @p10 = @p1051, @v10 = @v10 , @p11 = @p11, @v11 = @v11 , @p12 = @p12, @v12 = @v12 , @p13 = @p13, @v13 = @v13 , @p14 = @p14, @v14 = @v14 , @p15 = @p15, @v15 = @v15 , 52@p16 = @p16, @v16 = @v16 , @p17 = @p17, @v17 = @v17 , @p18 = @p18, @v18 = @v18 , @p19 = @p19, @v19 = @v19 ,  @p20 = @p20, @v20 = @v20 , @p21 = @p21, @v2153 = @v21 , @p22 = @p22, @v22 = @v22 , @p23 = @p23, @v23 = @v23 , @p24 = @p24, @v24 = @v24 , @p25 = @p25, @v25 = @v25 , @p26 = @p26, @v26 = @v26 , @p27 =54 @p27, @v27 = @v27 , @p28 = @p28, @v28 = @v28 , @p29 = @p29, @v29 = @v29 , @p30 = @p30, @v30 = @v30 , @p31 = @p31, @v31 = @v31,  @Priority = 12,    @checkForExisting55 =1  end else  begin select @MessageString = N'Job ' + @Name + N' not started, Time exceeded : ' + @StopTimeFull exec QBM_PJournal @MessageString, @@PROCID56, 'W', @DebugLevel end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R exec QBM_PSessionContextSet57 'XUser', @XUser_R declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende:  exec QBM_PSessionContextSet58 'GenProcID', @GenProcID_R exec QBM_PSessionContextSet 'XUser', @XUser_R return end 59