AnsweredAssumed Answered

recurring sql agent logs

Question asked by Utku Alp on Dec 26, 2016
Latest reply on Dec 27, 2016 by Chi_Chen

Dear all,

 

I see below recurring logs for last one hour. What is its reason? How can i stop it?

 

12/26 14:53:02.65 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:02.97 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:03.43 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:03.58 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:04.01 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:04.46 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:04.85 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:05.02 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>9CC60D54A12A34409E4A430BB3C70D24)

12/26 14:53:05.38 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:05.69 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:06.04 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:06.18 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:06.49 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:06.94 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:07.46 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:07.60 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>793ED69B4E87A545BD8E911834D829FC)

12/26 14:53:08.05 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

12/26 14:53:08.41 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

12/26 14:53:08.83 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

12/26 14:53:08.99 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>C851F3DD7E2F9043B5E8315A5FA84CD5)

12/26 14:53:09.44 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

12/26 14:53:09.88 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (10000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

12/26 14:53:10.33 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1010 SQL Query has returned (15000) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

12/26 14:53:10.51 sqlagt:select0 14704 SIGNIFICANT prov_base.c 1025 SQL Query has finished (16931) rows for (rpt_indtl.rpt-#10340/scolak). Clause (SELECT ca_contact.first_name, ca_contact.middle_name, ca_contact.last_name FROM ca_contact, usp_contact WHERE ca_contact.contact_uuid = ? AND ( ( ( usp_contact.zODYA_GroupLevelID != 3 AND usp_contact.zODYA_GroupLevelID != 5 ) AND ca_contact.contact_type = 2308 ) OR ( ca_contact.contact_type = 2305 OR ca_contact.contact_type = 2307 OR ca_contact.contact_type = 1000011 OR ca_contact.contact_type = 1000060 OR ca_contact.contact_type = 1000061 OR ca_contact.contact_type = 1000062 OR ca_contact.contact_type = 1000063 OR ca_contact.contact_type = 1000064 ) )) Input (<uuid>FB79852D17C4154881DA3C65B7549489)

Outcomes