CDC is not working in scheduling time

[Anonymous]

Hi all,

I have created a CDC tables while it's working fine when ever i used run button in talend.

Same jobs after scheduled these build jobs using task scheduler for every hour am getting ZERO records from these CDC tables.

source                     destination 

mssql ----------------->HIVE

NOte: From client side the mssql database is dropping  and recreating every night 10 pm.IS this cause any issue am getting zero records in hive by CDC tables.

Can anyone help me for this issue to resolve..

[manodwhb]

@saibabu ,what was the scheduled time? is it same time dropping and creating database ? if yes it could be problem.

[Anonymous]

Scheduled time was started 17-04-2019 4.00.00 am and it will run every one hour as Repeat task and Duration : - INDEFINITELY

[vapukov]

Hi @saibabu ,

of course it could be a problem

Talend use trigger based CDC, so when you drop the database, it must drop triggers on tables

[Anonymous]

But they are re-creating triggers every day @10 pm dropping & creating entire db again