• LastExecutionStartDate: Last start time from current job,
• LastExecutionStartDateSerial: From LastExecutionStartDate the date formatted as Interger: yyyyMMdd,
• LastExecutionStartTimeSerial: Formatted by LastExecutionStartDate the time as Interger: HHmm,
• LastExecutionEndDate: The time of the last completion of the current job,
• LastExecutionEndDateSerial: From LastExecutionEndDate the date formatted as an interger: yyyyMMdd,
• LastExecutionEndTimeSerial: The LastExecutionStartDat formats the time as Interger: HHmm,
• ExecuteEventId: For the Web service, the URI of the request.
• ExecuteEventId: For web service, the URI of the request.
• MaxRowsPerInsert: Deprecated and incorrectly defined, corresponds to SqlMaxInsertSize.
• SqlMaxInsertSize: Only for MS-SQL server, the number of characters for an insert statement. E.g. the default value 1024 stands for splitting the insert statement before its length exceeds 1024 characters.
• sqlcommandtimeout: Define a Timeout for an SQL statement.
• dontuseupdatetransaction: Do not issue an update statement.
• DontCheckCommitCount: Do not consider the number of commits.

Variables in the backend job step can contain placeholders according to Masks, which are evaluated at runtime.

This does not apply to:

• eBiss.DbAdapter.ConnectionString and.
• eBiss.DbAdapter.ConnectionType.

Used Variables:

• eBiss.DbAdapter.ConnectionString: the connection string
• eBiss.DbAdapter.ConnectionType: the db type (in .NET connection type format), e.g. 'IBM.Data.DB2.DB2Connection', 'System.Data.SqlClient.SqlConnection'.
• eBiss.DbAdapter.TraceSql: if this flag is set to true, you will get an extended tracing including full connection string.
• eBiss.DbAdapter.MsSqlReadPast: If you set the Boolean variable to true, than WITH(READPAST) is appended to the SELECT. If the variable is of type=Text, then you can freely define the value attached to the SELECT, e. g. = „WITH (NOLOCK)“.¹⁾
• eBiss.DbAdapter.Execute.Afterconnect.1: EXEC is executed as the first statement.