topic Duplicate Sql server jobs for pubilcation in Qlik Replicate

Duplicate Sql server jobs for pubilcation

epanosian — Thu, 03 Nov 2022 15:31:31 GMT

I see duplicate jobs for the same database on the same server:

serverA-databaseA-AR_PUBLICATION_00023-100 and

serverA-databaseA-AR_PUBLICATION_00023-99

Why do I have two jobs?

thank you,

Estifan

Re: Duplicate Sql server jobs for pubilcation

SwathiPulagam — Thu, 03 Nov 2022 17:48:49 GMT

Hi @epanosian ,

Go to SSMS-->SQL Server Agent-->Job activity monitor--> Take the screenshot of the Job activity monitor including the category name on all the jobs and share.

Thanks,

Swathi

Re: Duplicate Sql server jobs for pubilcation

epanosian — Thu, 03 Nov 2022 19:43:29 GMT

sorry I can't share more than this:

Re: Duplicate Sql server jobs for pubilcation

SwathiPulagam — Tue, 08 Nov 2022 22:45:34 GMT

Hi @epanosian ,

If Replicate creates a publication then it won't create Snapshot jobs. Below is the article for your reference:

https://community.qlik.com/t5/Official-Support-Articles/In-SQL-Server-if-Snapshot-Agent-is-turned-on-accidentally-then/ta-p/1899582

Thanks,

Swathi