Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
epanosian
Contributor
Contributor

Duplicate Sql server jobs for pubilcation

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

Labels (1)
1 Solution

Accepted Solutions
SwathiPulagam
Support
Support

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...

 

Thanks,

Swathi

View solution in original post

3 Replies
SwathiPulagam
Support
Support

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

epanosian
Contributor
Contributor
Author

sorry I can't share more than this:

epanosian_0-1667504477045.png

 

SwathiPulagam
Support
Support

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...

 

Thanks,

Swathi