Your code does not result in an error, so that explains why the CATCH block code is not executed.

Or is your question 'Why does this code not generate an error?'

• This reply was modified 2 years, 2 months ago by Phil Parkin.

To read data from a DB2 database on SQL Server 2017, you can use the Linked Server feature. First, create a linked server using the "sp_addlinkedserver" system stored procedure....

As Grantor is a column which is specific to your database, no one here is going to be able to help in any detail without additional information.

But, my assumption is...

Presumably, you've tried this and it did not work out the way you wanted?

SELECT *
FROM T1
    JOIN T2
      ...

Getting started with SSIS is a bit of a learning curve. I recommend you read a few of the stairway articles (link) to help you understand how everything fits...

Understood. But you mentioned 'SQLJob timings' and I was simply wanting to confirm that you had referred to this in error.

Hi Phil,

a) Whether a row is good or not - NOT

b) If a row is considered bad, how should its revised InTime or OutTime be derived? -

You mean the Event Viewer, presumably? OK, I don't know what to suggest...

OK, does it happen randomly, or only at set times?

Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'? - No, missed punch out for the 28th. I just described two...

Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'?

But if row 3 (28th) is good, why do you want to use its...

Is this something which has just started happening? If so, do you have any new jobs running which get data from other sources?

Welcome to the forum.

Please start a new thread, rather than hijacking this one.

Also, if you want...

DROP TABLE IF EXISTS #test2;

CREATE TABLE #test2
(
    tran_log_writes VARCHAR(8000) NULL
);

INSERT #test2
(
    tran_log_writes
)
VALUES
(N'db1: 245471085 (68491820 kB)');

SELECT t.tran_log_writes
     ...

This is easy in SSIS, if you are open to that.