Events — 500 matches, newest first
Cross-batch view of every per-job event written by the workers (Stages 2/3/4). Use this to find errors fast, e.g. Errors only · last 24h · Dispatch stage.
| When | Level | Stage | Template | Recipient | Message | ms | Job |
|---|---|---|---|---|---|---|---|
| 2026-08-22 03:26:24.949677 | Info | Dispatch | AssociateSummary | yogesh.jedhe@kwglobal.com |
Inserted into SentMail. MailId=5616c565-7d81-42e7-8176-fbe1f13a555b | job → | |
| 2026-08-22 03:26:24.946677 | Info | Dispatch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 1ms | 1 | job → |
| 2026-08-22 03:26:24.941689 | Info | Dispatch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=5616c565-7d81-42e7-8176-fbe1f13a555b, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032624_6288c6e0.xlsx') | job → | |
| 2026-08-22 03:26:24.884075 | Info | Dispatch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=5616c565-7d81-42e7-8176-fbe1f13a555b in 51ms (inserted) | 51 | job → |
| 2026-08-22 03:26:24.829075 | Info | Dispatch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='yogesh.jedhe@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='28c031e7-19b2-443d-a93a-c783cf778b8e') | job → | |
| 2026-08-22 03:26:24.798077 | Info | QA | AssociateSummary | yogesh.jedhe@kwglobal.com |
QA passed (15 check(s)) | 1062 | job → |
| 2026-08-22 03:26:23.520871 | Info | Render | AssociateSummary | yogesh.jedhe@kwglobal.com |
Rendered (595838 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 1558 | job → |
| 2026-08-22 03:26:22.003714 | Info | Render | AssociateSummary | yogesh.jedhe@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:26:21.963053 | Info | Render | AssociateSummary | yogesh.jedhe@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=yogesh.jedhe@kwglobal.com | job → | |
| 2026-08-22 03:26:21.884682 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
Wrote EmailComp_Job_Data (2406308 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 305116 | job → |
| 2026-08-22 03:26:21.545112 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
AssociateSummary fetched — associates=55, app_usage=596, web_usage=711, category_usage=399, timesheet=56 | job → | |
| 2026-08-22 03:26:21.502195 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:26:21.455124 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 56 row(s) in 173765ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 173765 | job → |
| 2026-08-22 03:25:39.385128 | Info | Dispatch | AssociateSummary | vivek.pereira@kwglobal.com |
Inserted into SentMail. MailId=e0523da6-7671-49a3-8c5e-aa0a6d723a6f | job → | |
| 2026-08-22 03:25:39.381130 | Info | Dispatch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 1ms | 1 | job → |
| 2026-08-22 03:25:39.377174 | Info | Dispatch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=e0523da6-7671-49a3-8c5e-aa0a6d723a6f, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032539_d72f6aaf.xlsx') | job → | |
| 2026-08-22 03:25:39.329174 | Info | Dispatch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=e0523da6-7671-49a3-8c5e-aa0a6d723a6f in 24ms (inserted) | 24 | job → |
| 2026-08-22 03:25:39.303132 | Info | Dispatch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='vivek.pereira@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='d93b94a4-028d-4281-bcdc-02a3e5f69eb6') | job → | |
| 2026-08-22 03:25:39.294127 | Info | QA | AssociateSummary | vivek.pereira@kwglobal.com |
QA passed (15 check(s)) | 156 | job → |
| 2026-08-22 03:25:39.083127 | Info | Render | AssociateSummary | vivek.pereira@kwglobal.com |
Rendered (39865 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 219 | job → |
| 2026-08-22 03:25:38.868484 | Info | Render | AssociateSummary | vivek.pereira@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:25:38.864277 | Info | Render | AssociateSummary | vivek.pereira@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=vivek.pereira@kwglobal.com | job → | |
| 2026-08-22 03:25:38.855314 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
Wrote EmailComp_Job_Data (152889 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 265456 | job → |
| 2026-08-22 03:25:38.844317 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
AssociateSummary fetched — associates=2, app_usage=37, web_usage=48, category_usage=21, timesheet=3 | job → | |
| 2026-08-22 03:25:38.825317 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:25:38.800314 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 3 row(s) in 183982ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 183982 | job → |
| 2026-08-22 03:24:44.062402 | Info | Dispatch | AssociateSummary | Vipin.Suthar@kwglobal.com |
Inserted into SentMail. MailId=3b659beb-7ca8-48ee-be0f-86e003bf7d75 | job → | |
| 2026-08-22 03:24:44.059355 | Info | Dispatch | AssociateSummary | Vipin.Suthar@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:24:44.054351 | Info | Dispatch | AssociateSummary | Vipin.Suthar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=3b659beb-7ca8-48ee-be0f-86e003bf7d75, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032444_b9c4268e.xlsx') | job → | |
| 2026-08-22 03:24:44.005352 | Info | Dispatch | AssociateSummary | Vipin.Suthar@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=3b659beb-7ca8-48ee-be0f-86e003bf7d75 in 4ms (inserted) | 4 | job → |
| 2026-08-22 03:24:43.996403 | Info | Dispatch | AssociateSummary | Vipin.Suthar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vipin.Suthar@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='d5f25b87-d600-4c50-89c3-16c8c2b52cce') | job → | |
| 2026-08-22 03:24:43.987360 | Info | QA | AssociateSummary | Vipin.Suthar@kwglobal.com |
QA passed (15 check(s)) | 171 | job → |
| 2026-08-22 03:24:43.813088 | Info | Render | AssociateSummary | Vipin.Suthar@kwglobal.com |
Rendered (28708 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 165 | job → |
| 2026-08-22 03:24:43.653087 | Info | Render | AssociateSummary | Vipin.Suthar@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:43.650106 | Info | Render | AssociateSummary | Vipin.Suthar@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Vipin.Suthar@kwglobal.com | job → | |
| 2026-08-22 03:24:43.641086 | Info | DataFetch | AssociateSummary | Vipin.Suthar@kwglobal.com |
Wrote EmailComp_Job_Data (59814 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 305453 | job → |
| 2026-08-22 03:24:43.630086 | Info | DataFetch | AssociateSummary | Vipin.Suthar@kwglobal.com |
AssociateSummary fetched — associates=1, app_usage=15, web_usage=15, category_usage=9, timesheet=2 | job → | |
| 2026-08-22 03:24:43.622086 | Info | DataFetch | AssociateSummary | Vipin.Suthar@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:43.616041 | Info | DataFetch | AssociateSummary | Vipin.Suthar@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 2 row(s) in 200881ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 200881 | job → |
| 2026-08-22 03:24:37.905857 | Info | Dispatch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
Inserted into SentMail. MailId=c7c96dc7-6055-4b45-af5c-ce52d9922479 | job → | |
| 2026-08-22 03:24:37.902856 | Info | Dispatch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:24:37.899857 | Info | Dispatch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=c7c96dc7-6055-4b45-af5c-ce52d9922479, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032437_39d10b8e.xlsx') | job → | |
| 2026-08-22 03:24:37.850857 | Info | Dispatch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=c7c96dc7-6055-4b45-af5c-ce52d9922479 in 11ms (inserted) | 11 | job → |
| 2026-08-22 03:24:37.837856 | Info | Dispatch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vishal.Bhandare@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='8d0f0822-e1eb-420c-8653-fc0e5ea39fa5') | job → | |
| 2026-08-22 03:24:37.829856 | Info | QA | AssociateSummary | Vishal.Bhandare@kwglobal.com |
QA passed (15 check(s)) | 328 | job → |
| 2026-08-22 03:24:37.483835 | Info | Render | AssociateSummary | Vishal.Bhandare@kwglobal.com |
Rendered (38035 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 190 | job → |
| 2026-08-22 03:24:37.296620 | Info | Render | AssociateSummary | Vishal.Bhandare@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:37.293585 | Info | Render | AssociateSummary | Vishal.Bhandare@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Vishal.Bhandare@kwglobal.com | job → | |
| 2026-08-22 03:24:37.287581 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
Wrote EmailComp_Job_Data (43852 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 231731 | job → |
| 2026-08-22 03:24:37.281581 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
AssociateSummary fetched — associates=2, app_usage=16, web_usage=1, category_usage=7, timesheet=3 | job → | |
| 2026-08-22 03:24:37.278575 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:37.273621 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 3 row(s) in 150355ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 150355 | job → |
| 2026-08-22 03:24:29.670748 | Info | Dispatch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
Inserted into SentMail. MailId=b648e74b-89ac-4099-95e4-b4f0d523e766 | job → | |
| 2026-08-22 03:24:29.657747 | Info | Dispatch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:24:29.647750 | Info | Dispatch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=b648e74b-89ac-4099-95e4-b4f0d523e766, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032429_da94f38f.xlsx') | job → | |
| 2026-08-22 03:24:29.583704 | Info | Dispatch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=b648e74b-89ac-4099-95e4-b4f0d523e766 in 18ms (inserted) | 18 | job → |
| 2026-08-22 03:24:29.563589 | Info | Dispatch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Yuvaraj.Selvaraj@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='b885254f-ec42-4ebf-b657-373c86e0a95b') | job → | |
| 2026-08-22 03:24:29.555590 | Info | QA | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
QA passed (15 check(s)) | 218 | job → |
| 2026-08-22 03:24:29.338542 | Info | Render | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
Rendered (60987 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 242 | job → |
| 2026-08-22 03:24:29.100495 | Info | Render | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:29.097492 | Info | Render | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Yuvaraj.Selvaraj@kwglobal.com | job → | |
| 2026-08-22 03:24:29.079448 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
Wrote EmailComp_Job_Data (201548 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 177999 | job → |
| 2026-08-22 03:24:29.066448 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
AssociateSummary fetched — associates=4, app_usage=78, web_usage=38, category_usage=25, timesheet=5 | job → | |
| 2026-08-22 03:24:29.063444 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:29.059443 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 5 row(s) in 102590ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 102590 | job → |
| 2026-08-22 03:24:28.285957 | Info | Dispatch | AssociateSummary | virender.negi@kwglobal.com |
Inserted into SentMail. MailId=dcd7ebc8-1fd3-4c0c-b975-23f09972d236 | job → | |
| 2026-08-22 03:24:28.282959 | Info | Dispatch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 0ms | job → | |
| 2026-08-22 03:24:28.279965 | Info | Dispatch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=dcd7ebc8-1fd3-4c0c-b975-23f09972d236, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032428_1ab4d883.xlsx') | job → | |
| 2026-08-22 03:24:28.231953 | Info | Dispatch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=dcd7ebc8-1fd3-4c0c-b975-23f09972d236 in 6ms (inserted) | 6 | job → |
| 2026-08-22 03:24:28.223961 | Info | Dispatch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='virender.negi@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='51e791f7-1031-4d4b-90d8-f09ab73fc18f') | job → | |
| 2026-08-22 03:24:28.217958 | Info | QA | AssociateSummary | virender.negi@kwglobal.com |
QA passed (15 check(s)) | 110 | job → |
| 2026-08-22 03:24:28.086955 | Info | Render | AssociateSummary | virender.negi@kwglobal.com |
Rendered (60055 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 220 | job → |
| 2026-08-22 03:24:27.869344 | Info | Render | AssociateSummary | virender.negi@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:27.867345 | Info | Render | AssociateSummary | virender.negi@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=virender.negi@kwglobal.com | job → | |
| 2026-08-22 03:24:27.861300 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
Wrote EmailComp_Job_Data (181010 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 236970 | job → |
| 2026-08-22 03:24:27.853303 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
AssociateSummary fetched — associates=4, app_usage=55, web_usage=46, category_usage=26, timesheet=5 | job → | |
| 2026-08-22 03:24:27.850298 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:27.846346 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 5 row(s) in 96052ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileNo | 96052 | job → |
| 2026-08-22 03:24:21.463319 | Info | Dispatch | AssociateSummary | vinod.parab@kwglobal.com |
Inserted into SentMail. MailId=55f706ca-4ac8-4b70-80ab-86e97a1e4f27 | job → | |
| 2026-08-22 03:24:21.460318 | Info | Dispatch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 1ms | 1 | job → |
| 2026-08-22 03:24:21.456326 | Info | Dispatch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=55f706ca-4ac8-4b70-80ab-86e97a1e4f27, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032421_0500b8db.xlsx') | job → | |
| 2026-08-22 03:24:21.405269 | Info | Dispatch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=55f706ca-4ac8-4b70-80ab-86e97a1e4f27 in 8ms (inserted) | 8 | job → |
| 2026-08-22 03:24:21.394317 | Info | Dispatch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='vinod.parab@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='7af1e59c-7d70-4001-83a1-2d5b39021811') | job → | |
| 2026-08-22 03:24:21.380321 | Info | QA | AssociateSummary | vinod.parab@kwglobal.com |
QA passed (15 check(s)) | 296 | job → |
| 2026-08-22 03:24:21.071506 | Info | Render | AssociateSummary | vinod.parab@kwglobal.com |
Rendered (92656 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 260 | job → |
| 2026-08-22 03:24:20.813710 | Info | Render | AssociateSummary | vinod.parab@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:20.811751 | Info | Render | AssociateSummary | vinod.parab@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=vinod.parab@kwglobal.com | job → | |
| 2026-08-22 03:24:20.771708 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
Wrote EmailComp_Job_Data (340041 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 311041 | job → |
| 2026-08-22 03:24:20.733713 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
AssociateSummary fetched — associates=7, app_usage=122, web_usage=77, category_usage=42, timesheet=8 | job → | |
| 2026-08-22 03:24:20.713749 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:20.699757 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 8 row(s) in 94384ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileNo | 94384 | job → |
| 2026-08-22 03:24:13.927981 | Info | Dispatch | AssociateSummary | vimal.srivastava@kwglobal.com |
Inserted into SentMail. MailId=06e714f9-6cdc-4b10-addd-0e813c27a107 | job → | |
| 2026-08-22 03:24:13.924959 | Info | Dispatch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:24:13.905013 | Info | Dispatch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=06e714f9-6cdc-4b10-addd-0e813c27a107, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032413_5c34fa58.xlsx') | job → | |
| 2026-08-22 03:24:13.849964 | Info | Dispatch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=06e714f9-6cdc-4b10-addd-0e813c27a107 in 14ms (inserted) | 14 | job → |
| 2026-08-22 03:24:13.833009 | Info | Dispatch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='vimal.srivastava@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='4bf94cdb-2780-4bb6-9c80-f0eee0283eb2') | job → | |
| 2026-08-22 03:24:13.807351 | Info | QA | AssociateSummary | vimal.srivastava@kwglobal.com |
QA passed (15 check(s)) | 485 | job → |
| 2026-08-22 03:24:13.299378 | Info | Render | AssociateSummary | vimal.srivastava@kwglobal.com |
Rendered (50406 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 198 | job → |
| 2026-08-22 03:24:13.118379 | Info | Render | AssociateSummary | vimal.srivastava@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:13.103379 | Info | Render | AssociateSummary | vimal.srivastava@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=vimal.srivastava@kwglobal.com | job → | |
| 2026-08-22 03:24:13.094383 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
Wrote EmailComp_Job_Data (117862 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 306097 | job → |
| 2026-08-22 03:24:13.085233 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
AssociateSummary fetched — associates=3, app_usage=48, web_usage=12, category_usage=19, timesheet=4 | job → | |
| 2026-08-22 03:24:13.065427 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:13.047427 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 4 row(s) in 88405ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileNo | 88405 | job → |
| 2026-08-22 03:24:03.768537 | Info | Dispatch | AssociateSummary | vijay.anand@kwglobal.com |
Inserted into SentMail. MailId=4abaf851-865b-4736-9f6b-0fd45e34186e | job → | |
| 2026-08-22 03:24:03.765539 | Info | Dispatch | AssociateSummary | vijay.anand@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:24:03.761536 | Info | Dispatch | AssociateSummary | vijay.anand@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=4abaf851-865b-4736-9f6b-0fd45e34186e, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032403_678990f2.xlsx') | job → | |
| 2026-08-22 03:24:03.716535 | Info | Dispatch | AssociateSummary | vijay.anand@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=4abaf851-865b-4736-9f6b-0fd45e34186e in 9ms (inserted) | 9 | job → |
| 2026-08-22 03:24:03.704541 | Info | Dispatch | AssociateSummary | vijay.anand@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='vijay.anand@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='a47d77b3-7dc1-42e3-8969-ec86c45e0be4') | job → | |
| 2026-08-22 03:24:03.695572 | Info | QA | AssociateSummary | vijay.anand@kwglobal.com |
QA passed (15 check(s)) | 108 | job → |
| 2026-08-22 03:24:03.567536 | Info | Render | AssociateSummary | vijay.anand@kwglobal.com |
Rendered (29234 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 217 | job → |
| 2026-08-22 03:24:03.354537 | Info | Render | AssociateSummary | vijay.anand@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:24:03.351535 | Info | Render | AssociateSummary | vijay.anand@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=vijay.anand@kwglobal.com | job → | |
| 2026-08-22 03:24:03.343535 | Info | DataFetch | AssociateSummary | vijay.anand@kwglobal.com |
Wrote EmailComp_Job_Data (92014 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 306983 | job → |
| 2026-08-22 03:24:03.321534 | Info | DataFetch | AssociateSummary | vijay.anand@kwglobal.com |
AssociateSummary fetched — associates=1, app_usage=25, web_usage=24, category_usage=16, timesheet=2 | job → | |
| 2026-08-22 03:24:03.317544 | Info | DataFetch | AssociateSummary | vijay.anand@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:24:03.245535 | Info | DataFetch | AssociateSummary | vijay.anand@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 2 row(s) in 180256ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 180256 | job → |
| 2026-08-22 03:23:27.684925 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='B8BB6F37-9EFF-40C1-A3FC-8A7A7034C8B4', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:23:27.659922 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 399 row(s) in 355ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_r | 355 | job → |
| 2026-08-22 03:23:27.278710 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='B8BB6F37-9EFF-40C1-A3FC-8A7A7034C8B4', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:23:27.244718 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 711 row(s) in 254ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 254 | job → |
| 2026-08-22 03:23:26.981279 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='B8BB6F37-9EFF-40C1-A3FC-8A7A7034C8B4', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:23:26.964280 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 596 row(s) in 151ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson] | 151 | job → |
| 2026-08-22 03:23:26.810277 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='B8BB6F37-9EFF-40C1-A3FC-8A7A7034C8B4', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:23:26.805278 | Info | DataFetch | AssociateSummary | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 55 row(s) in 130333ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAtte | 130333 | job → |
| 2026-08-22 03:23:02.418726 | Info | Dispatch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
Inserted into SentMail. MailId=764a6dc2-fb73-4bb4-94ca-a563b7c4f09a | job → | |
| 2026-08-22 03:23:02.404690 | Info | Dispatch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 6ms | 6 | job → |
| 2026-08-22 03:23:02.396688 | Info | Dispatch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=764a6dc2-fb73-4bb4-94ca-a563b7c4f09a, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032302_f1351e21.xlsx') | job → | |
| 2026-08-22 03:23:02.332687 | Info | Dispatch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=764a6dc2-fb73-4bb4-94ca-a563b7c4f09a in 12ms (inserted) | 12 | job → |
| 2026-08-22 03:23:02.311686 | Info | Dispatch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vignesh.Subramanian@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='3bbbffad-5265-414d-a651-287d62debd5d') | job → | |
| 2026-08-22 03:23:02.295698 | Info | QA | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
QA passed (15 check(s)) | 407 | job → |
| 2026-08-22 03:23:01.812341 | Info | Render | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
Rendered (91756 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 353 | job → |
| 2026-08-22 03:23:01.464341 | Info | Render | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:23:01.462340 | Info | Render | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Vignesh.Subramanian@kwglobal.com | job → | |
| 2026-08-22 03:23:01.453335 | Info | DataFetch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
Wrote EmailComp_Job_Data (260593 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 248860 | job → |
| 2026-08-22 03:23:01.406336 | Info | DataFetch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
AssociateSummary fetched — associates=7, app_usage=91, web_usage=50, category_usage=38, timesheet=8 | job → | |
| 2026-08-22 03:23:01.393340 | Info | DataFetch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:23:01.387382 | Info | DataFetch | AssociateSummary | Vignesh.Subramanian@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 8 row(s) in 133390ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 133390 | job → |
| 2026-08-22 03:22:54.697900 | Info | Dispatch | AssociateSummary | Veena.Mathew@kwglobal.com |
Inserted into SentMail. MailId=4f5b2401-8c46-4a9b-a5c5-f40af6428ac0 | job → | |
| 2026-08-22 03:22:54.677854 | Info | Dispatch | AssociateSummary | Veena.Mathew@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 14ms | 14 | job → |
| 2026-08-22 03:22:54.638899 | Info | Dispatch | AssociateSummary | Veena.Mathew@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=4f5b2401-8c46-4a9b-a5c5-f40af6428ac0, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032254_b9b4e43c.xlsx') | job → | |
| 2026-08-22 03:22:54.582902 | Info | Dispatch | AssociateSummary | Veena.Mathew@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=4f5b2401-8c46-4a9b-a5c5-f40af6428ac0 in 42ms (inserted) | 42 | job → |
| 2026-08-22 03:22:54.537255 | Info | Dispatch | AssociateSummary | Veena.Mathew@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Veena.Mathew@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='48e965bb-a95d-4eec-88ea-2b7fe8f973d8') | job → | |
| 2026-08-22 03:22:54.500253 | Info | QA | AssociateSummary | Veena.Mathew@kwglobal.com |
QA passed (15 check(s)) | 281 | job → |
| 2026-08-22 03:22:54.182252 | Info | Render | AssociateSummary | Veena.Mathew@kwglobal.com |
Rendered (50390 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 237 | job → |
| 2026-08-22 03:22:53.976639 | Info | Render | AssociateSummary | Veena.Mathew@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:22:53.957638 | Info | Render | AssociateSummary | Veena.Mathew@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Veena.Mathew@kwglobal.com | job → | |
| 2026-08-22 03:22:53.918633 | Info | DataFetch | AssociateSummary | Veena.Mathew@kwglobal.com |
Wrote EmailComp_Job_Data (132802 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 317051 | job → |
| 2026-08-22 03:22:53.861352 | Info | DataFetch | AssociateSummary | Veena.Mathew@kwglobal.com |
AssociateSummary fetched — associates=3, app_usage=42, web_usage=26, category_usage=22, timesheet=4 | job → | |
| 2026-08-22 03:22:53.847398 | Info | DataFetch | AssociateSummary | Veena.Mathew@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:22:53.827350 | Info | DataFetch | AssociateSummary | Veena.Mathew@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 4 row(s) in 215199ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,MobileN | 215199 | job → |
| 2026-08-22 03:22:51.789651 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='EA6CC45B-13CC-4F6B-9A41-D81F121A3A5A', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:51.785606 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 26 row(s) in 135ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_ro | 135 | job → |
| 2026-08-22 03:22:51.647330 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='EA6CC45B-13CC-4F6B-9A41-D81F121A3A5A', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:51.642330 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 46 row(s) in 51ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; f | 51 | job → |
| 2026-08-22 03:22:51.588330 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='EA6CC45B-13CC-4F6B-9A41-D81F121A3A5A', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:51.578309 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 55 row(s) in 141ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 141 | job → |
| 2026-08-22 03:22:51.434654 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='EA6CC45B-13CC-4F6B-9A41-D81F121A3A5A', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:51.429645 | Info | DataFetch | AssociateSummary | virender.negi@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 4 row(s) in 140539ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAtten | 140539 | job → |
| 2026-08-22 03:22:48.055632 | Info | Dispatch | AssociateSummary | tribon.krishnan@kwglobal.com |
Inserted into SentMail. MailId=2cdc922b-7304-4530-9640-57358f682787 | job → | |
| 2026-08-22 03:22:48.024635 | Info | Dispatch | AssociateSummary | tribon.krishnan@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:22:48.015635 | Info | Dispatch | AssociateSummary | tribon.krishnan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=2cdc922b-7304-4530-9640-57358f682787, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032247_2a1473cf.xlsx') | job → | |
| 2026-08-22 03:22:47.964633 | Info | Dispatch | AssociateSummary | tribon.krishnan@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=2cdc922b-7304-4530-9640-57358f682787 in 6ms (inserted) | 6 | job → |
| 2026-08-22 03:22:47.954638 | Info | Dispatch | AssociateSummary | tribon.krishnan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='tribon.krishnan@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='56ea3255-46f3-474e-998e-fc2c00ea7252') | job → | |
| 2026-08-22 03:22:47.924636 | Info | QA | AssociateSummary | tribon.krishnan@kwglobal.com |
QA passed (15 check(s)) | 281 | job → |
| 2026-08-22 03:22:47.587630 | Info | Render | AssociateSummary | tribon.krishnan@kwglobal.com |
Rendered (123459 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 256 | job → |
| 2026-08-22 03:22:47.340026 | Info | Render | AssociateSummary | tribon.krishnan@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:22:47.327033 | Info | Render | AssociateSummary | tribon.krishnan@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=tribon.krishnan@kwglobal.com | job → | |
| 2026-08-22 03:22:47.320026 | Info | DataFetch | AssociateSummary | tribon.krishnan@kwglobal.com |
Wrote EmailComp_Job_Data (281438 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 344698 | job → |
| 2026-08-22 03:22:47.244172 | Info | DataFetch | AssociateSummary | tribon.krishnan@kwglobal.com |
AssociateSummary fetched — associates=10, app_usage=122, web_usage=24, category_usage=43, timesheet=11 | job → | |
| 2026-08-22 03:22:47.240178 | Info | DataFetch | AssociateSummary | tribon.krishnan@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:22:47.226171 | Info | DataFetch | AssociateSummary | tribon.krishnan@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 11 row(s) in 275465ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 275465 | job → |
| 2026-08-22 03:22:46.465050 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='8E5CAE6B-B43A-4767-BDAC-EA312072952D', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:46.459092 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 25 row(s) in 201ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_ro | 201 | job → |
| 2026-08-22 03:22:46.310041 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='C937C68F-47EA-4841-8875-2D8DC104A54C', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:46.297040 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 42 row(s) in 266ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_ro | 266 | job → |
| 2026-08-22 03:22:46.254037 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='8E5CAE6B-B43A-4767-BDAC-EA312072952D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:46.249039 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 38 row(s) in 111ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 111 | job → |
| 2026-08-22 03:22:46.134039 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='8E5CAE6B-B43A-4767-BDAC-EA312072952D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:46.129039 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 78 row(s) in 95ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 95 | job → |
| 2026-08-22 03:22:46.031557 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='8E5CAE6B-B43A-4767-BDAC-EA312072952D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:46.028554 | Info | DataFetch | AssociateSummary | Yuvaraj.Selvaraj@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 4 row(s) in 74955ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttend | 74955 | job → |
| 2026-08-22 03:22:46.027557 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='C937C68F-47EA-4841-8875-2D8DC104A54C', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:46.021514 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 77 row(s) in 85ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; f | 85 | job → |
| 2026-08-22 03:22:45.932554 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='C937C68F-47EA-4841-8875-2D8DC104A54C', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:45.925509 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 122 row(s) in 82ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 82 | job → |
| 2026-08-22 03:22:45.839504 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='C937C68F-47EA-4841-8875-2D8DC104A54C', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:45.833508 | Info | DataFetch | AssociateSummary | vinod.parab@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 216085ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAtten | 216085 | job → |
| 2026-08-22 03:22:44.636901 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='E0A4A6F0-38ED-4270-9E92-064E821A1697', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:44.615845 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 19 row(s) in 156ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_ro | 156 | job → |
| 2026-08-22 03:22:44.435220 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='E0A4A6F0-38ED-4270-9E92-064E821A1697', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:44.389174 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 12 row(s) in 149ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 149 | job → |
| 2026-08-22 03:22:44.215171 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='E0A4A6F0-38ED-4270-9E92-064E821A1697', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:44.198177 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 48 row(s) in 58ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 58 | job → |
| 2026-08-22 03:22:44.137167 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='E0A4A6F0-38ED-4270-9E92-064E821A1697', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:44.127213 | Info | DataFetch | AssociateSummary | vimal.srivastava@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 3 row(s) in 217130ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAtten | 217130 | job → |
| 2026-08-22 03:22:42.961217 | Info | Dispatch | AssociateSummary | Usha.Nadar@kwglobal.com |
Inserted into SentMail. MailId=b07e9228-1a4a-4f67-8564-20c5f8fdcdb9 | job → | |
| 2026-08-22 03:22:42.919217 | Info | Dispatch | AssociateSummary | Usha.Nadar@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 0ms | job → | |
| 2026-08-22 03:22:42.894216 | Info | Dispatch | AssociateSummary | Usha.Nadar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=b07e9228-1a4a-4f67-8564-20c5f8fdcdb9, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032242_4eb68375.xlsx') | job → | |
| 2026-08-22 03:22:42.823217 | Info | Dispatch | AssociateSummary | Usha.Nadar@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=b07e9228-1a4a-4f67-8564-20c5f8fdcdb9 in 62ms (inserted) | 62 | job → |
| 2026-08-22 03:22:42.738156 | Info | Dispatch | AssociateSummary | Usha.Nadar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Usha.Nadar@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='50dcad8a-416a-4cfc-8973-8cd738cfd7d3') | job → | |
| 2026-08-22 03:22:42.688120 | Info | QA | AssociateSummary | Usha.Nadar@kwglobal.com |
QA passed (15 check(s)) | 264 | job → |
| 2026-08-22 03:22:42.384801 | Info | Render | AssociateSummary | Usha.Nadar@kwglobal.com |
Rendered (280202 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 822 | job → |
| 2026-08-22 03:22:41.580453 | Info | Render | AssociateSummary | Usha.Nadar@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:22:41.563452 | Info | Render | AssociateSummary | Usha.Nadar@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Usha.Nadar@kwglobal.com | job → | |
| 2026-08-22 03:22:41.554453 | Info | DataFetch | AssociateSummary | Usha.Nadar@kwglobal.com |
Wrote EmailComp_Job_Data (1235808 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 314536 | job → |
| 2026-08-22 03:22:41.441449 | Info | DataFetch | AssociateSummary | Usha.Nadar@kwglobal.com |
AssociateSummary fetched — associates=25, app_usage=384, web_usage=347, category_usage=160, timesheet=26 | job → | |
| 2026-08-22 03:22:41.412454 | Info | DataFetch | AssociateSummary | Usha.Nadar@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:22:41.400451 | Info | DataFetch | AssociateSummary | Usha.Nadar@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 26 row(s) in 147292ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 147292 | job → |
| 2026-08-22 03:22:34.812232 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='689EECF7-06C4-4132-A230-2C801D5B602D', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:34.802232 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 21 row(s) in 554ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_ro | 554 | job → |
| 2026-08-22 03:22:34.228547 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='689EECF7-06C4-4132-A230-2C801D5B602D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:34.208585 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 48 row(s) in 70ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; f | 70 | job → |
| 2026-08-22 03:22:34.127588 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='689EECF7-06C4-4132-A230-2C801D5B602D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:34.101582 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 37 row(s) in 42ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 42 | job → |
| 2026-08-22 03:22:34.037451 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='689EECF7-06C4-4132-A230-2C801D5B602D', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:34.033455 | Info | DataFetch | AssociateSummary | vivek.pereira@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 2 row(s) in 80637ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttend | 80637 | job → |
| 2026-08-22 03:22:28.061145 | Info | Dispatch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
Inserted into SentMail. MailId=6adcb5db-5d53-4705-bea8-64cf5e1e8b30 | job → | |
| 2026-08-22 03:22:28.058143 | Info | Dispatch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:22:28.053151 | Info | Dispatch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=6adcb5db-5d53-4705-bea8-64cf5e1e8b30, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032228_bba44d43.xlsx') | job → | |
| 2026-08-22 03:22:28.006145 | Info | Dispatch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=6adcb5db-5d53-4705-bea8-64cf5e1e8b30 in 35ms (inserted) | 35 | job → |
| 2026-08-22 03:22:27.968151 | Info | Dispatch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vidhya.Velayudhan@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='5b32e087-7c79-4bbf-8cf5-bc561a1d4075') | job → | |
| 2026-08-22 03:22:27.903139 | Info | QA | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
QA passed (15 check(s)) | 515 | job → |
| 2026-08-22 03:22:27.268919 | Info | Render | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
Rendered (617329 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 1106 | job → |
| 2026-08-22 03:22:26.152677 | Info | Render | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:22:26.149670 | Info | Render | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=Vidhya.Velayudhan@kwglobal.com | job → | |
| 2026-08-22 03:22:26.139677 | Info | DataFetch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
Wrote EmailComp_Job_Data (2687848 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 274518 | job → |
| 2026-08-22 03:22:25.992238 | Info | DataFetch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
AssociateSummary fetched — associates=57, app_usage=586, web_usage=1030, category_usage=285, timesheet=58 | job → | |
| 2026-08-22 03:22:25.968240 | Info | DataFetch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:22:25.933240 | Info | DataFetch | AssociateSummary | Vidhya.Velayudhan@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 58 row(s) in 131498ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 131498 | job → |
| 2026-08-22 03:22:06.898100 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-08-21', @DateTo='2026-08-21', @OperationsPerformedBy='631CF942-AA7E-4258-B160-B4F37FB8E313', @EmployeeSearchText=NULL, @IncludeEmployeeDetails=1, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) | job → | |
| 2026-08-22 03:22:06.870099 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 7 row(s) in 441ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; first_row | 441 | job → |
| 2026-08-22 03:22:06.410308 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsForLineManager=1, @LineManagerId='631CF942-AA7E-4258-B160-B4F37FB8E313', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:06.375226 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 1 row(s) in 111ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; f | 111 | job → |
| 2026-08-22 03:22:06.244772 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=0, @IsForLineManager=1, @LineManagerId='631CF942-AA7E-4258-B160-B4F37FB8E313', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:06.232772 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 16 row(s) in 106ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber,DepartmentName,ReportToEmployeeName,SkipSupervisorName,TeamName,BranchName,FormJson,FormDataJson]; | 106 | job → |
| 2026-08-22 03:22:06.122771 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-21', @IsApp=1, @IsForLineManager=1, @LineManagerId='631CF942-AA7E-4258-B160-B4F37FB8E313', @IncludeEmployeeDetails=1) | job → | |
| 2026-08-22 03:22:06.091236 | Info | DataFetch | AssociateSummary | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_UserDailyTrackerReport returned 2 row(s) in 80529ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttend | 80529 | job → |
| 2026-08-22 03:22:05.366801 | Info | Dispatch | AssociateSummary | thomas.pt@kwglobal.com |
Inserted into SentMail. MailId=67328a50-849c-4179-a55a-3fc6622f1604 | job → | |
| 2026-08-22 03:22:05.337843 | Info | Dispatch | AssociateSummary | thomas.pt@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:22:05.310800 | Info | Dispatch | AssociateSummary | thomas.pt@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=67328a50-849c-4179-a55a-3fc6622f1604, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032205_ea2a0c03.xlsx') | job → | |
| 2026-08-22 03:22:05.240834 | Info | Dispatch | AssociateSummary | thomas.pt@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=67328a50-849c-4179-a55a-3fc6622f1604 in 15ms (inserted) | 15 | job → |
| 2026-08-22 03:22:05.216799 | Info | Dispatch | AssociateSummary | thomas.pt@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='thomas.pt@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='bb989ca2-838f-4470-bf49-38f04f4c0e04') | job → | |
| 2026-08-22 03:22:05.205803 | Info | QA | AssociateSummary | thomas.pt@kwglobal.com |
QA passed (15 check(s)) | 641 | job → |
| 2026-08-22 03:22:04.508771 | Info | Render | AssociateSummary | thomas.pt@kwglobal.com |
Rendered (261901 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 378 | job → |
| 2026-08-22 03:22:04.134763 | Info | Render | AssociateSummary | thomas.pt@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:22:04.124763 | Info | Render | AssociateSummary | thomas.pt@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=thomas.pt@kwglobal.com | job → | |
| 2026-08-22 03:22:04.102764 | Info | DataFetch | AssociateSummary | thomas.pt@kwglobal.com |
Wrote EmailComp_Job_Data (827147 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 360125 | job → |
| 2026-08-22 03:22:04.021176 | Info | DataFetch | AssociateSummary | thomas.pt@kwglobal.com |
AssociateSummary fetched — associates=23, app_usage=315, web_usage=125, category_usage=141, timesheet=24 | job → | |
| 2026-08-22 03:22:04.012177 | Info | DataFetch | AssociateSummary | thomas.pt@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:22:03.994171 | Info | DataFetch | AssociateSummary | thomas.pt@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 24 row(s) in 227111ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 227111 | job → |
| 2026-08-22 03:21:59.789743 | Info | Dispatch | AssociateSummary | topaze.nicolette@kwglobal.com |
Inserted into SentMail. MailId=9d0a980c-304d-416b-8a0d-4f50d6d2b779 | job → | |
| 2026-08-22 03:21:59.759739 | Info | Dispatch | AssociateSummary | topaze.nicolette@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 0ms | job → | |
| 2026-08-22 03:21:59.728141 | Info | Dispatch | AssociateSummary | topaze.nicolette@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=9d0a980c-304d-416b-8a0d-4f50d6d2b779, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/AssociateSummary_2026-08-21_20260822-032159_447f0e78.xlsx') | job → | |
| 2026-08-22 03:21:59.662138 | Info | Dispatch | AssociateSummary | topaze.nicolette@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=9d0a980c-304d-416b-8a0d-4f50d6d2b779 in 35ms (inserted) | 35 | job → |
| 2026-08-22 03:21:59.625140 | Info | Dispatch | AssociateSummary | topaze.nicolette@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='topaze.nicolette@kwglobal.com', @Subject='Daily associates summary report - Aug 21, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='958d8fcc-fc75-4a65-8ab7-6f5f691ba9b2') | job → | |
| 2026-08-22 03:21:59.564529 | Info | QA | AssociateSummary | topaze.nicolette@kwglobal.com |
QA passed (15 check(s)) | 203 | job → |
| 2026-08-22 03:21:59.318521 | Info | Render | AssociateSummary | topaze.nicolette@kwglobal.com |
Rendered (145677 bytes, subject='Daily associates summary report - Aug 21, 2026', attachments=1) | 438 | job → |
| 2026-08-22 03:21:58.888974 | Info | Render | AssociateSummary | topaze.nicolette@kwglobal.com |
dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:58.876928 | Info | Render | AssociateSummary | topaze.nicolette@kwglobal.com |
--- Stage 3 begin --- template=AssociateSummary recipient=topaze.nicolette@kwglobal.com | job → | |
| 2026-08-22 03:21:58.821928 | Info | DataFetch | AssociateSummary | topaze.nicolette@kwglobal.com |
Wrote EmailComp_Job_Data (635683 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] | 314003 | job → |
| 2026-08-22 03:21:58.732921 | Info | DataFetch | AssociateSummary | topaze.nicolette@kwglobal.com |
AssociateSummary fetched — associates=12, app_usage=251, web_usage=119, category_usage=79, timesheet=13 | job → | |
| 2026-08-22 03:21:58.713926 | Info | DataFetch | AssociateSummary | topaze.nicolette@kwglobal.com |
Soft labels: batch-cache hit (105 keys) | job → | |
| 2026-08-22 03:21:58.689926 | Info | DataFetch | AssociateSummary | topaze.nicolette@kwglobal.com |
<<< USP_EmailComp_DownloadTimesheet returned 13 row(s) in 182870ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,SkipSupervisorName,EmployeeEmail,FormJson,FormDataJson,TimeOnSystemInSec,Shift,DepartmentName,Mobile | 182870 | job → |
| 2026-08-22 03:21:47.472027 | Info | Dispatch | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
Inserted into SentMail. MailId=4ba5827d-5002-42cd-b9d5-bb247a591e28 | job → | |
| 2026-08-22 03:21:47.469021 | Info | Dispatch | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 16ms | 16 | job → |
| 2026-08-22 03:21:47.450024 | Info | Dispatch | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=4ba5827d-5002-42cd-b9d5-bb247a591e28, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032147_6143dd6d.xlsx') | job → | |
| 2026-08-22 03:21:47.404020 | Info | Dispatch | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=4ba5827d-5002-42cd-b9d5-bb247a591e28 in 20ms (inserted) | 20 | job → |
| 2026-08-22 03:21:47.364017 | Info | Dispatch | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Rajeev.Barowalia@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='8d92beb6-8937-4ecc-9aee-c3308fc07b8 | job → | |
| 2026-08-22 03:21:47.344022 | Info | QA | UrgentAttention | Rajeev.Barowalia@kwglobal.com |
QA passed (15 check(s)) | 5906 | job → |
| 2026-08-22 03:21:44.680326 | Info | Dispatch | UrgentAttention | yogesh.jedhe@kwglobal.com |
Inserted into SentMail. MailId=da0d8b87-f750-4fc5-939e-b6798273defb | job → | |
| 2026-08-22 03:21:44.666315 | Info | Dispatch | UrgentAttention | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 16ms | 16 | job → |
| 2026-08-22 03:21:44.647293 | Info | Dispatch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
Inserted into SentMail. MailId=cdc8df7e-951c-4835-9da4-1b2059a2dd3a | job → | |
| 2026-08-22 03:21:44.637290 | Info | Dispatch | UrgentAttention | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=da0d8b87-f750-4fc5-939e-b6798273defb, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_e271ce98.xlsx') | job → | |
| 2026-08-22 03:21:44.626287 | Info | Dispatch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 21ms | 21 | job → |
| 2026-08-22 03:21:44.603326 | Info | Dispatch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=cdc8df7e-951c-4835-9da4-1b2059a2dd3a, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_e3b1d3be.xlsx') | job → | |
| 2026-08-22 03:21:44.582290 | Info | Dispatch | UrgentAttention | yogesh.jedhe@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=da0d8b87-f750-4fc5-939e-b6798273defb in 78ms (inserted) | 78 | job → |
| 2026-08-22 03:21:44.548742 | Info | Dispatch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=cdc8df7e-951c-4835-9da4-1b2059a2dd3a in 34ms (inserted) | 34 | job → |
| 2026-08-22 03:21:44.516744 | Info | Dispatch | UrgentAttention | virender.negi@kwglobal.com |
Inserted into SentMail. MailId=e404bcc4-a24e-44d9-a6ef-67e0275b0396 | job → | |
| 2026-08-22 03:21:44.514742 | Info | Dispatch | UrgentAttention | virender.negi@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 12ms | 12 | job → |
| 2026-08-22 03:21:44.501739 | Info | Dispatch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vishal.Bhandare@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='6c2cb842-f049-4f99-8e08-5d7331d666b0 | job → | |
| 2026-08-22 03:21:44.499739 | Info | Dispatch | UrgentAttention | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=e404bcc4-a24e-44d9-a6ef-67e0275b0396, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_18f6da61.xlsx') | job → | |
| 2026-08-22 03:21:44.489739 | Info | Dispatch | UrgentAttention | yogesh.jedhe@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='yogesh.jedhe@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='0a9c6167-37cf-4362-a712-5ca342083bfd') | job → | |
| 2026-08-22 03:21:44.462740 | Info | QA | UrgentAttention | yogesh.jedhe@kwglobal.com |
QA passed (15 check(s)) | 202 | job → |
| 2026-08-22 03:21:44.449756 | Info | Dispatch | UrgentAttention | virender.negi@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=e404bcc4-a24e-44d9-a6ef-67e0275b0396 in 62ms (inserted) | 62 | job → |
| 2026-08-22 03:21:44.441738 | Info | QA | UrgentAttention | Vishal.Bhandare@kwglobal.com |
QA passed (15 check(s)) | 358 | job → |
| 2026-08-22 03:21:44.412737 | Info | Dispatch | UrgentAttention | Usha.Nadar@kwglobal.com |
Inserted into SentMail. MailId=c9e7d4a9-9060-4249-9b48-308db036bd32 | job → | |
| 2026-08-22 03:21:44.406739 | Info | Dispatch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
Inserted into SentMail. MailId=bae343cb-6d66-42ed-86e1-c85d59c8c068 | job → | |
| 2026-08-22 03:21:44.401742 | Info | Dispatch | UrgentAttention | tribon.krishnan@kwglobal.com |
Inserted into SentMail. MailId=0d465900-c233-4e11-9ef1-225fe4713f34 | job → | |
| 2026-08-22 03:21:44.399739 | Info | Dispatch | UrgentAttention | tribon.krishnan@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 11ms | 11 | job → |
| 2026-08-22 03:21:44.399739 | Info | Dispatch | UrgentAttention | Usha.Nadar@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 12ms | 12 | job → |
| 2026-08-22 03:21:44.386738 | Info | Dispatch | UrgentAttention | tribon.krishnan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=0d465900-c233-4e11-9ef1-225fe4713f34, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_69fc8834.xlsx') | job → | |
| 2026-08-22 03:21:44.378739 | Info | Dispatch | UrgentAttention | virender.negi@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='virender.negi@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='525df557-f104-49f1-8c10-7beab1951746') | job → | |
| 2026-08-22 03:21:44.376737 | Info | Dispatch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
Inserted into SentMail. MailId=9309f204-edc1-4bac-af88-aba4baa16f92 | job → | |
| 2026-08-22 03:21:44.368737 | Info | Dispatch | UrgentAttention | Usha.Nadar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=c9e7d4a9-9060-4249-9b48-308db036bd32, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_ceabb0bb.xlsx') | job → | |
| 2026-08-22 03:21:44.360739 | Info | Dispatch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 13ms | 13 | job → |
| 2026-08-22 03:21:44.360739 | Info | Dispatch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 13ms | 13 | job → |
| 2026-08-22 03:21:44.350741 | Info | Dispatch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
Inserted into SentMail. MailId=ccdd9c2a-b8cd-408c-be3d-f8a2e9bc40e7 | job → | |
| 2026-08-22 03:21:44.344739 | Info | Dispatch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=9309f204-edc1-4bac-af88-aba4baa16f92, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_09f7e50c.xlsx') | job → | |
| 2026-08-22 03:21:44.340737 | Info | Dispatch | UrgentAttention | tribon.krishnan@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=0d465900-c233-4e11-9ef1-225fe4713f34 in 107ms (inserted) | 107 | job → |
| 2026-08-22 03:21:44.338739 | Info | Dispatch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=bae343cb-6d66-42ed-86e1-c85d59c8c068, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_be7a8a60.xlsx') | job → | |
| 2026-08-22 03:21:44.338739 | Info | Dispatch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 12ms | 12 | job → |
| 2026-08-22 03:21:44.320737 | Info | QA | UrgentAttention | virender.negi@kwglobal.com |
QA passed (15 check(s)) | 266 | job → |
| 2026-08-22 03:21:44.307739 | Info | Dispatch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=ccdd9c2a-b8cd-408c-be3d-f8a2e9bc40e7, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_dccb7439.xlsx') | job → | |
| 2026-08-22 03:21:44.301740 | Info | Dispatch | UrgentAttention | Usha.Nadar@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=c9e7d4a9-9060-4249-9b48-308db036bd32 in 37ms (inserted) | 37 | job → |
| 2026-08-22 03:21:44.289740 | Info | Dispatch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=9309f204-edc1-4bac-af88-aba4baa16f92 in 21ms (inserted) | 21 | job → |
| 2026-08-22 03:21:44.277742 | Info | Dispatch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=bae343cb-6d66-42ed-86e1-c85d59c8c068 in 58ms (inserted) | 58 | job → |
| 2026-08-22 03:21:44.262743 | Info | Dispatch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vidhya.Velayudhan@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='3879e81c-52fe-4f3b-9115-1ed6d49d27 | job → | |
| 2026-08-22 03:21:44.261742 | Info | Dispatch | UrgentAttention | Usha.Nadar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Usha.Nadar@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='79190459-98e5-4935-acf4-f748d23ec235') | job → | |
| 2026-08-22 03:21:44.241737 | Info | Render | UrgentAttention | yogesh.jedhe@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 195 | job → |
| 2026-08-22 03:21:44.226738 | Info | Dispatch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=ccdd9c2a-b8cd-408c-be3d-f8a2e9bc40e7 in 48ms (inserted) | 48 | job → |
| 2026-08-22 03:21:44.222736 | Info | Dispatch | UrgentAttention | sumit.gupta@kwglobal.com |
Inserted into SentMail. MailId=208a945e-1881-462f-87dc-35c5b758c329 | job → | |
| 2026-08-22 03:21:44.217744 | Info | Dispatch | UrgentAttention | tribon.krishnan@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='tribon.krishnan@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='cf3fd57a-08ff-428f-bae3-d2c381197ce7 | job → | |
| 2026-08-22 03:21:44.216737 | Info | Dispatch | UrgentAttention | sumit.gupta@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 6ms | 6 | job → |
| 2026-08-22 03:21:44.215737 | Info | Dispatch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Vignesh.Subramanian@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='0cdfef7c-b4aa-4c64-8f33-0ef315f4 | job → | |
| 2026-08-22 03:21:44.209738 | Info | QA | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
QA passed (15 check(s)) | 297 | job → |
| 2026-08-22 03:21:44.204741 | Info | Dispatch | UrgentAttention | suresh.menon@kwglobal.com |
Inserted into SentMail. MailId=a7979dcb-b61d-4414-9d3b-0df935f6f9aa | job → | |
| 2026-08-22 03:21:44.196735 | Info | Dispatch | UrgentAttention | sumit.gupta@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=208a945e-1881-462f-87dc-35c5b758c329, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_bdc3561b.xlsx') | job → | |
| 2026-08-22 03:21:44.185737 | Info | Dispatch | UrgentAttention | suresh.menon@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 8ms | 8 | job → |
| 2026-08-22 03:21:44.185737 | Info | Dispatch | UrgentAttention | suresh.pasunkili@kwglobal.com |
Inserted into SentMail. MailId=1429f633-b7a3-453a-8fac-8966b30f8daa | job → | |
| 2026-08-22 03:21:44.165739 | Info | Dispatch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Tarak.Jadhav@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='698ad12e-bd50-4c7d-9c56-add10f19f6a1') | job → | |
| 2026-08-22 03:21:44.156738 | Info | Dispatch | UrgentAttention | suresh.menon@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=a7979dcb-b61d-4414-9d3b-0df935f6f9aa, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_cb483eed.xlsx') | job → | |
| 2026-08-22 03:21:44.154739 | Info | Dispatch | UrgentAttention | suresh.pasunkili@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 11ms | 11 | job → |
| 2026-08-22 03:21:44.149745 | Info | QA | UrgentAttention | Usha.Nadar@kwglobal.com |
QA passed (15 check(s)) | 312 | job → |
| 2026-08-22 03:21:44.142741 | Info | QA | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
QA passed (15 check(s)) | 328 | job → |
| 2026-08-22 03:21:44.139736 | Info | Dispatch | UrgentAttention | suresh.pasunkili@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=1429f633-b7a3-453a-8fac-8966b30f8daa, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032144_3d77a4c2.xlsx') | job → | |
| 2026-08-22 03:21:44.119739 | Info | QA | UrgentAttention | Tarak.Jadhav@kwglobal.com |
QA passed (15 check(s)) | 389 | job → |
| 2026-08-22 03:21:44.117735 | Info | QA | UrgentAttention | tribon.krishnan@kwglobal.com |
QA passed (15 check(s)) | 375 | job → |
| 2026-08-22 03:21:44.111739 | Info | Dispatch | UrgentAttention | sumit.gupta@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=208a945e-1881-462f-87dc-35c5b758c329 in 29ms (inserted) | 29 | job → |
| 2026-08-22 03:21:44.082735 | Info | Dispatch | UrgentAttention | suresh.menon@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=a7979dcb-b61d-4414-9d3b-0df935f6f9aa in 26ms (inserted) | 26 | job → |
| 2026-08-22 03:21:44.071736 | Info | Render | UrgentAttention | yogesh.jedhe@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:44.067737 | Info | Dispatch | UrgentAttention | suresh.pasunkili@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=1429f633-b7a3-453a-8fac-8966b30f8daa in 18ms (inserted) | 18 | job → |
| 2026-08-22 03:21:44.061736 | Info | Dispatch | UrgentAttention | sumit.gupta@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='sumit.gupta@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='a8d1c6be-bcd7-4a7d-938a-cc334b826d02') | job → | |
| 2026-08-22 03:21:44.055742 | Info | Render | UrgentAttention | Vishal.Bhandare@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 165 | job → |
| 2026-08-22 03:21:44.051734 | Info | Render | UrgentAttention | yogesh.jedhe@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=yogesh.jedhe@kwglobal.com | job → | |
| 2026-08-22 03:21:44.050734 | Info | Dispatch | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
Inserted into SentMail. MailId=6433c8c0-9a42-4836-89e1-9c69ac254c00 | job → | |
| 2026-08-22 03:21:44.045736 | Info | Dispatch | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 20ms | 20 | job → |
| 2026-08-22 03:21:44.043732 | Info | Render | UrgentAttention | virender.negi@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 98 | job → |
| 2026-08-22 03:21:44.043732 | Info | Dispatch | UrgentAttention | suresh.menon@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='suresh.menon@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='9c83fdc0-5fb8-4806-96ad-4ebf0fd85374') | job → | |
| 2026-08-22 03:21:44.039735 | Info | Dispatch | UrgentAttention | suresh.pasunkili@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='suresh.pasunkili@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='f9d601ed-bea0-4a8f-9b89-f88b728c6fb | job → | |
| 2026-08-22 03:21:44.012735 | Info | Dispatch | UrgentAttention | sivagnanamoorthy@kwglobal.com |
Inserted into SentMail. MailId=0cf0a6ac-5859-469d-a573-6521de6c8753 | job → | |
| 2026-08-22 03:21:44.006747 | Info | Dispatch | UrgentAttention | sumit.emerald@kwglobal.com |
Inserted into SentMail. MailId=5055eadd-525f-4c74-a369-ab7cdb80a939 | job → | |
| 2026-08-22 03:21:43.995738 | Info | Dispatch | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=6433c8c0-9a42-4836-89e1-9c69ac254c00, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_7311ce2b.xlsx') | job → | |
| 2026-08-22 03:21:43.987736 | Info | Dispatch | UrgentAttention | sumit.emerald@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 8ms | 8 | job → |
| 2026-08-22 03:21:43.984737 | Info | QA | UrgentAttention | suresh.menon@kwglobal.com |
QA passed (15 check(s)) | 562 | job → |
| 2026-08-22 03:21:43.971743 | Info | QA | UrgentAttention | suresh.pasunkili@kwglobal.com |
QA passed (15 check(s)) | 406 | job → |
| 2026-08-22 03:21:43.962735 | Info | QA | UrgentAttention | sumit.gupta@kwglobal.com |
QA passed (15 check(s)) | 687 | job → |
| 2026-08-22 03:21:43.961737 | Info | Dispatch | UrgentAttention | sumit.emerald@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=5055eadd-525f-4c74-a369-ab7cdb80a939, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_4c5b56d9.xlsx') | job → | |
| 2026-08-22 03:21:43.959735 | Info | Render | UrgentAttention | virender.negi@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.958737 | Info | DataFetch | UrgentAttention | Yuvaraj.Selvaraj@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=8e5cae6b-b43a-4767-bdac-ea312072952d | 8 | job → |
| 2026-08-22 03:21:43.953735 | Info | DataFetch | UrgentAttention | Yuvaraj.Selvaraj@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=8e5cae6b-b43a-4767-bdac-ea312072952d -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.951736 | Info | DataFetch | UrgentAttention | yogesh.jedhe@kwglobal.com |
Wrote EmailComp_Job_Data (9075 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 7 | job → |
| 2026-08-22 03:21:43.945736 | Info | Dispatch | UrgentAttention | sivagnanamoorthy@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 30ms | 30 | job → |
| 2026-08-22 03:21:43.945736 | Info | Render | UrgentAttention | virender.negi@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=virender.negi@kwglobal.com | job → | |
| 2026-08-22 03:21:43.940734 | Info | Render | UrgentAttention | Vishal.Bhandare@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.923734 | Info | DataFetch | UrgentAttention | Yuvaraj.Selvaraj@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Yuvaraj.Selvaraj@kwglobal.com userId=8E5CAE6B-B43A-4767-BDAC-EA312072952D | job → | |
| 2026-08-22 03:21:43.917737 | Info | Dispatch | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=6433c8c0-9a42-4836-89e1-9c69ac254c00 in 27ms (inserted) | 27 | job → |
| 2026-08-22 03:21:43.905737 | Info | DataFetch | UrgentAttention | yogesh.jedhe@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=b8bb6f37-9eff-40c1-a3fc-8a7a7034c8b4 -> 6 row(s) | job → | |
| 2026-08-22 03:21:43.902734 | Info | Render | UrgentAttention | Vishal.Bhandare@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=Vishal.Bhandare@kwglobal.com | job → | |
| 2026-08-22 03:21:43.896736 | Info | DataFetch | UrgentAttention | yogesh.jedhe@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=yogesh.jedhe@kwglobal.com userId=B8BB6F37-9EFF-40C1-A3FC-8A7A7034C8B4 | job → | |
| 2026-08-22 03:21:43.890733 | Info | Dispatch | UrgentAttention | sumit.emerald@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=5055eadd-525f-4c74-a369-ab7cdb80a939 in 25ms (inserted) | 25 | job → |
| 2026-08-22 03:21:43.883734 | Info | DataFetch | UrgentAttention | virender.negi@kwglobal.com |
Wrote EmailComp_Job_Data (1585 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 43 | job → |
| 2026-08-22 03:21:43.874733 | Info | Dispatch | UrgentAttention | sivagnanamoorthy@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=0cf0a6ac-5859-469d-a573-6521de6c8753, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_9b96198d.xlsx') | job → | |
| 2026-08-22 03:21:43.869735 | Info | Render | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 209 | job → |
| 2026-08-22 03:21:43.869735 | Info | Dispatch | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='suresh.kalyanaraman@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='abac5bdf-f401-419d-9d4d-06e0342d | job → | |
| 2026-08-22 03:21:43.866734 | Info | DataFetch | UrgentAttention | vivek.pereira@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=689eecf7-06c4-4132-a230-2c801d5b602d | 16 | job → |
| 2026-08-22 03:21:43.854732 | Info | DataFetch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
Wrote EmailComp_Job_Data (1592 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 13 | job → |
| 2026-08-22 03:21:43.854732 | Info | Dispatch | UrgentAttention | sumit.emerald@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='sumit.emerald@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='b1ee6efe-70b7-4c2b-85a2-b3113dec069e') | job → | |
| 2026-08-22 03:21:43.851736 | Info | DataFetch | UrgentAttention | vivek.pereira@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=689eecf7-06c4-4132-a230-2c801d5b602d -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.847732 | Info | QA | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
QA passed (15 check(s)) | 468 | job → |
| 2026-08-22 03:21:43.831737 | Info | DataFetch | UrgentAttention | vivek.pereira@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=vivek.pereira@kwglobal.com userId=689EECF7-06C4-4132-A230-2C801D5B602D | job → | |
| 2026-08-22 03:21:43.812737 | Info | Dispatch | UrgentAttention | sivagnanamoorthy@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=0cf0a6ac-5859-469d-a573-6521de6c8753 in 38ms (inserted) | 38 | job → |
| 2026-08-22 03:21:43.811733 | Info | DataFetch | UrgentAttention | virender.negi@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=ea6cc45b-13cc-4f6b-9a41-d81f121a3a5a -> 1 row(s) | job → | |
| 2026-08-22 03:21:43.802733 | Info | Render | UrgentAttention | Usha.Nadar@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 130 | job → |
| 2026-08-22 03:21:43.795734 | Info | DataFetch | UrgentAttention | virender.negi@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=virender.negi@kwglobal.com userId=EA6CC45B-13CC-4F6B-9A41-D81F121A3A5A | job → | |
| 2026-08-22 03:21:43.789733 | Info | QA | UrgentAttention | sumit.emerald@kwglobal.com |
QA passed (15 check(s)) | 406 | job → |
| 2026-08-22 03:21:43.788732 | Info | Render | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 119 | job → |
| 2026-08-22 03:21:43.788732 | Info | DataFetch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=631cf942-aa7e-4258-b160-b4f37fb8e313 -> 1 row(s) | job → | |
| 2026-08-22 03:21:43.780737 | Info | DataFetch | UrgentAttention | Vishal.Bhandare@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Vishal.Bhandare@kwglobal.com userId=631CF942-AA7E-4258-B160-B4F37FB8E313 | job → | |
| 2026-08-22 03:21:43.778735 | Info | Dispatch | UrgentAttention | sumukh.byndoor@kwglobal.com |
Inserted into SentMail. MailId=51f2ce70-929d-41c8-9103-342ceb9cdf99 | job → | |
| 2026-08-22 03:21:43.771732 | Info | DataFetch | UrgentAttention | Vipin.Suthar@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=383d7088-d782-4cd4-9deb-ca8d649f9be4 | 13 | job → |
| 2026-08-22 03:21:43.762744 | Info | Dispatch | UrgentAttention | sivagnanamoorthy@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='sivagnanamoorthy@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='14cfa86e-defb-430b-bdc1-1e1b53b349c | job → | |
| 2026-08-22 03:21:43.760739 | Info | DataFetch | UrgentAttention | Vipin.Suthar@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=383d7088-d782-4cd4-9deb-ca8d649f9be4 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.744732 | Info | DataFetch | UrgentAttention | Vipin.Suthar@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Vipin.Suthar@kwglobal.com userId=383D7088-D782-4CD4-9DEB-CA8D649F9BE4 | job → | |
| 2026-08-22 03:21:43.741730 | Info | DataFetch | UrgentAttention | vinod.parab@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=c937c68f-47ea-4841-8875-2d8dc104a54c | 24 | job → |
| 2026-08-22 03:21:43.737731 | Info | Dispatch | UrgentAttention | sumukh.byndoor@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 24ms | 24 | job → |
| 2026-08-22 03:21:43.719738 | Info | DataFetch | UrgentAttention | vinod.parab@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=c937c68f-47ea-4841-8875-2d8dc104a54c -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.717741 | Info | DataFetch | UrgentAttention | vimal.srivastava@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=e0a4a6f0-38ed-4270-9e92-064e821a1697 | 33 | job → |
| 2026-08-22 03:21:43.700731 | Info | DataFetch | UrgentAttention | vinod.parab@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=vinod.parab@kwglobal.com userId=C937C68F-47EA-4841-8875-2D8DC104A54C | job → | |
| 2026-08-22 03:21:43.700731 | Info | Render | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.691735 | Info | DataFetch | UrgentAttention | vimal.srivastava@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=e0a4a6f0-38ed-4270-9e92-064e821a1697 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.689729 | Info | Dispatch | UrgentAttention | sumukh.byndoor@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=51f2ce70-929d-41c8-9103-342ceb9cdf99, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_317756c8.xlsx') | job → | |
| 2026-08-22 03:21:43.689729 | Info | Render | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.688732 | Info | DataFetch | UrgentAttention | vijay.anand@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=71f0389d-081c-4e55-a55f-98dd12b6566b | 8 | job → |
| 2026-08-22 03:21:43.680733 | Info | DataFetch | UrgentAttention | vijay.anand@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=71f0389d-081c-4e55-a55f-98dd12b6566b -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.680733 | Info | QA | UrgentAttention | sivagnanamoorthy@kwglobal.com |
QA passed (15 check(s)) | 468 | job → |
| 2026-08-22 03:21:43.680733 | Info | Render | UrgentAttention | tribon.krishnan@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 149 | job → |
| 2026-08-22 03:21:43.679737 | Info | Render | UrgentAttention | Usha.Nadar@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.673732 | Info | DataFetch | UrgentAttention | vimal.srivastava@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=vimal.srivastava@kwglobal.com userId=E0A4A6F0-38ED-4270-9E92-064E821A1697 | job → | |
| 2026-08-22 03:21:43.672748 | Info | Render | UrgentAttention | Usha.Nadar@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=Usha.Nadar@kwglobal.com | job → | |
| 2026-08-22 03:21:43.670730 | Info | Render | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=Vignesh.Subramanian@kwglobal.com | job → | |
| 2026-08-22 03:21:43.670730 | Info | DataFetch | UrgentAttention | vijay.anand@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=vijay.anand@kwglobal.com userId=71F0389D-081C-4E55-A55F-98DD12B6566B | job → | |
| 2026-08-22 03:21:43.670730 | Info | Render | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=Vidhya.Velayudhan@kwglobal.com | job → | |
| 2026-08-22 03:21:43.657731 | Info | Render | UrgentAttention | Tarak.Jadhav@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 93 | job → |
| 2026-08-22 03:21:43.635730 | Info | DataFetch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
Wrote EmailComp_Job_Data (1600 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 5 | job → |
| 2026-08-22 03:21:43.635730 | Info | Dispatch | UrgentAttention | sumukh.byndoor@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=51f2ce70-929d-41c8-9103-342ceb9cdf99 in 86ms (inserted) | 86 | job → |
| 2026-08-22 03:21:43.631735 | Info | DataFetch | UrgentAttention | Veena.Mathew@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=59ac1101-f930-4a0a-b073-752e5efe3368 | 4 | job → |
| 2026-08-22 03:21:43.623732 | Info | Dispatch | UrgentAttention | sithi.vinayagam@kwglobal.com |
Inserted into SentMail. MailId=433db645-4bba-4516-a4e9-ecac10175648 | job → | |
| 2026-08-22 03:21:43.621731 | Info | DataFetch | UrgentAttention | Veena.Mathew@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=59ac1101-f930-4a0a-b073-752e5efe3368 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.611860 | Info | DataFetch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
Wrote EmailComp_Job_Data (7738 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 9 | job → |
| 2026-08-22 03:21:43.610734 | Info | DataFetch | UrgentAttention | Usha.Nadar@kwglobal.com |
Wrote EmailComp_Job_Data (4573 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 48 | job → |
| 2026-08-22 03:21:43.594736 | Info | DataFetch | UrgentAttention | Veena.Mathew@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Veena.Mathew@kwglobal.com userId=59AC1101-F930-4A0A-B073-752E5EFE3368 | job → | |
| 2026-08-22 03:21:43.584729 | Info | Dispatch | UrgentAttention | sithi.vinayagam@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 25ms | 25 | job → |
| 2026-08-22 03:21:43.580731 | Info | DataFetch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=2fa19e2d-2266-4093-a13e-44adfd3bbeab -> 1 row(s) | job → | |
| 2026-08-22 03:21:43.577730 | Info | DataFetch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=996ae856-cbfb-45b5-81d6-a962e269bf4a -> 5 row(s) | job → | |
| 2026-08-22 03:21:43.571728 | Info | DataFetch | UrgentAttention | Vignesh.Subramanian@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Vignesh.Subramanian@kwglobal.com userId=2FA19E2D-2266-4093-A13E-44ADFD3BBEAB | job → | |
| 2026-08-22 03:21:43.568732 | Info | DataFetch | UrgentAttention | Vidhya.Velayudhan@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Vidhya.Velayudhan@kwglobal.com userId=996AE856-CBFB-45B5-81D6-A962E269BF4A | job → | |
| 2026-08-22 03:21:43.567732 | Info | Render | UrgentAttention | Tarak.Jadhav@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.558733 | Info | Render | UrgentAttention | Tarak.Jadhav@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=Tarak.Jadhav@kwglobal.com | job → | |
| 2026-08-22 03:21:43.554731 | Info | Dispatch | UrgentAttention | sithi.vinayagam@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=433db645-4bba-4516-a4e9-ecac10175648, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_a5d3bf69.xlsx') | job → | |
| 2026-08-22 03:21:43.541740 | Info | Dispatch | UrgentAttention | sumukh.byndoor@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='sumukh.byndoor@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='8f2725b9-8cca-44c2-8c85-c3a52203231f' | job → | |
| 2026-08-22 03:21:43.539733 | Info | Dispatch | UrgentAttention | soundarya.jayanth@kwglobal.com |
Inserted into SentMail. MailId=17db54dc-2a8f-4636-9d81-2e67d739825e | job → | |
| 2026-08-22 03:21:43.538735 | Info | DataFetch | UrgentAttention | Vandit.Nagvekar@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=a455aff0-a482-45df-8e84-72b53915ef77 | 5 | job → |
| 2026-08-22 03:21:43.536741 | Info | DataFetch | UrgentAttention | Vandit.Nagvekar@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=a455aff0-a482-45df-8e84-72b53915ef77 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.536741 | Info | Dispatch | UrgentAttention | soundarya.jayanth@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 3ms | 3 | job → |
| 2026-08-22 03:21:43.536741 | Info | Render | UrgentAttention | tribon.krishnan@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.532731 | Info | Render | UrgentAttention | tribon.krishnan@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=tribon.krishnan@kwglobal.com | job → | |
| 2026-08-22 03:21:43.531732 | Info | DataFetch | UrgentAttention | Usha.Nadar@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=c2c8a2d0-a511-42c7-8121-35d36adbe3d1 -> 3 row(s) | job → | |
| 2026-08-22 03:21:43.531732 | Info | DataFetch | UrgentAttention | Vandit.Nagvekar@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Vandit.Nagvekar@kwglobal.com userId=A455AFF0-A482-45DF-8E84-72B53915EF77 | job → | |
| 2026-08-22 03:21:43.530732 | Info | Dispatch | UrgentAttention | soundarya.jayanth@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=17db54dc-2a8f-4636-9d81-2e67d739825e, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_0032666a.xlsx') | job → | |
| 2026-08-22 03:21:43.526730 | Info | Dispatch | UrgentAttention | senthil.b@kwglobal.com |
Inserted into SentMail. MailId=d9d2ee6b-4123-413d-80fb-425152618867 | job → | |
| 2026-08-22 03:21:43.513729 | Info | Render | UrgentAttention | suresh.pasunkili@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 209 | job → |
| 2026-08-22 03:21:43.511730 | Info | DataFetch | UrgentAttention | tribon.krishnan@kwglobal.com |
Wrote EmailComp_Job_Data (1573 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 49 | job → |
| 2026-08-22 03:21:43.511730 | Info | Dispatch | UrgentAttention | senthil.b@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 3ms | 3 | job → |
| 2026-08-22 03:21:43.502732 | Info | DataFetch | UrgentAttention | Usha.Nadar@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Usha.Nadar@kwglobal.com userId=C2C8A2D0-A511-42C7-8121-35D36ADBE3D1 | job → | |
| 2026-08-22 03:21:43.502732 | Info | QA | UrgentAttention | sumukh.byndoor@kwglobal.com |
QA passed (15 check(s)) | 327 | job → |
| 2026-08-22 03:21:43.496735 | Info | Dispatch | UrgentAttention | senthil.b@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=d9d2ee6b-4123-413d-80fb-425152618867, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_67c95b81.xlsx') | job → | |
| 2026-08-22 03:21:43.492733 | Info | DataFetch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
Wrote EmailComp_Job_Data (15065 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 35 | job → |
| 2026-08-22 03:21:43.487733 | Info | Dispatch | UrgentAttention | sithi.vinayagam@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=433db645-4bba-4516-a4e9-ecac10175648 in 32ms (inserted) | 32 | job → |
| 2026-08-22 03:21:43.482729 | Info | Dispatch | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
Inserted into SentMail. MailId=98a54b27-a24a-424c-ab48-1c566c2f3f01 | job → | |
| 2026-08-22 03:21:43.480732 | Info | DataFetch | UrgentAttention | topaze.nicolette@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=5014c053-19aa-4c55-b407-f1e3de31f6f0 | 8 | job → |
| 2026-08-22 03:21:43.467727 | Info | Dispatch | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 8ms | 8 | job → |
| 2026-08-22 03:21:43.467727 | Info | Dispatch | UrgentAttention | soundarya.jayanth@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=17db54dc-2a8f-4636-9d81-2e67d739825e in 22ms (inserted) | 22 | job → |
| 2026-08-22 03:21:43.466728 | Info | DataFetch | UrgentAttention | topaze.nicolette@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=5014c053-19aa-4c55-b407-f1e3de31f6f0 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.461727 | Info | DataFetch | UrgentAttention | tribon.krishnan@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=6f8811ce-050b-491d-ba29-8cc900b8a01e -> 1 row(s) | job → | |
| 2026-08-22 03:21:43.452728 | Info | DataFetch | UrgentAttention | topaze.nicolette@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=topaze.nicolette@kwglobal.com userId=5014C053-19AA-4C55-B407-F1E3DE31F6F0 | job → | |
| 2026-08-22 03:21:43.446731 | Info | DataFetch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=17b94877-7879-45f9-884b-26a9015f1284 -> 10 row(s) | job → | |
| 2026-08-22 03:21:43.437730 | Info | DataFetch | UrgentAttention | tribon.krishnan@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=tribon.krishnan@kwglobal.com userId=6F8811CE-050B-491D-BA29-8CC900B8A01E | job → | |
| 2026-08-22 03:21:43.434728 | Info | Dispatch | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=98a54b27-a24a-424c-ab48-1c566c2f3f01, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_14894e49.xlsx') | job → | |
| 2026-08-22 03:21:43.433734 | Info | Dispatch | UrgentAttention | sithi.vinayagam@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='sithi.vinayagam@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='2484f816-5fe0-49fd-8da2-dbb6e47b6b73 | job → | |
| 2026-08-22 03:21:43.431731 | Info | Dispatch | UrgentAttention | soundarya.jayanth@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='soundarya.jayanth@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='101975bd-fbc2-45cf-9141-904e5afc1e | job → | |
| 2026-08-22 03:21:43.423735 | Info | Dispatch | UrgentAttention | senthil.b@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=d9d2ee6b-4123-413d-80fb-425152618867 in 34ms (inserted) | 34 | job → |
| 2026-08-22 03:21:43.411739 | Info | DataFetch | UrgentAttention | Tarak.Jadhav@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Tarak.Jadhav@kwglobal.com userId=17B94877-7879-45F9-884B-26A9015F1284 | job → | |
| 2026-08-22 03:21:43.405728 | Info | DataFetch | UrgentAttention | thomas.pt@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=593215ff-1252-4f18-9712-1986d8635259 | 6 | job → |
| 2026-08-22 03:21:43.402729 | Info | DataFetch | UrgentAttention | thomas.pt@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=593215ff-1252-4f18-9712-1986d8635259 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.400729 | Info | QA | UrgentAttention | soundarya.jayanth@kwglobal.com |
QA passed (15 check(s)) | 264 | job → |
| 2026-08-22 03:21:43.400729 | Info | Render | UrgentAttention | suresh.menon@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 163 | job → |
| 2026-08-22 03:21:43.400729 | Info | Dispatch | UrgentAttention | Shamin.Dsouza@kwglobal.com |
Inserted into SentMail. MailId=cebe320a-e9c0-4708-8409-59ecdacfd2d8 | job → | |
| 2026-08-22 03:21:43.395733 | Info | DataFetch | UrgentAttention | thomas.pt@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=thomas.pt@kwglobal.com userId=593215FF-1252-4F18-9712-1986D8635259 | job → | |
| 2026-08-22 03:21:43.381732 | Info | Dispatch | UrgentAttention | Shamin.Dsouza@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 7ms | 7 | job → |
| 2026-08-22 03:21:43.380733 | Info | QA | UrgentAttention | sithi.vinayagam@kwglobal.com |
QA passed (15 check(s)) | 375 | job → |
| 2026-08-22 03:21:43.368733 | Info | Dispatch | UrgentAttention | senthil.b@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='senthil.b@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='c4f732e4-f061-4436-b861-ebc059b97845') | job → | |
| 2026-08-22 03:21:43.364737 | Info | Dispatch | UrgentAttention | Shamin.Dsouza@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=cebe320a-e9c0-4708-8409-59ecdacfd2d8, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_7fd9e5b0.xlsx') | job → | |
| 2026-08-22 03:21:43.360727 | Info | Dispatch | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=98a54b27-a24a-424c-ab48-1c566c2f3f01 in 27ms (inserted) | 27 | job → |
| 2026-08-22 03:21:43.355730 | Info | DataFetch | UrgentAttention | Sushma.Desai@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=13b4965b-b5b7-44ca-a0de-e9b8747e9427 | 13 | job → |
| 2026-08-22 03:21:43.350730 | Info | DataFetch | UrgentAttention | Tanya.Chouhan@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=0323b19f-72c5-4f47-9fce-b0e61364c559 | 11 | job → |
| 2026-08-22 03:21:43.342765 | Info | Render | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 166 | job → |
| 2026-08-22 03:21:43.340733 | Info | DataFetch | UrgentAttention | Tanaya.Chimnani@kwglobal.com |
Skipping: UrgentAttention: no rows for HrUserId=92a06c10-1801-4b0f-b83f-bfe93d2c9e39 | 6 | job → |
| 2026-08-22 03:21:43.336733 | Info | DataFetch | UrgentAttention | Tanya.Chouhan@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=0323b19f-72c5-4f47-9fce-b0e61364c559 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.333726 | Info | DataFetch | UrgentAttention | Sushma.Desai@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=13b4965b-b5b7-44ca-a0de-e9b8747e9427 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.333726 | Info | Render | UrgentAttention | suresh.pasunkili@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.331727 | Info | DataFetch | UrgentAttention | Tanaya.Chimnani@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=92a06c10-1801-4b0f-b83f-bfe93d2c9e39 -> 0 row(s) | job → | |
| 2026-08-22 03:21:43.329728 | Info | DataFetch | UrgentAttention | Tanya.Chouhan@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Tanya.Chouhan@kwglobal.com userId=0323B19F-72C5-4F47-9FCE-B0E61364C559 | job → | |
| 2026-08-22 03:21:43.325733 | Info | DataFetch | UrgentAttention | Sushma.Desai@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Sushma.Desai@kwglobal.com userId=13B4965B-B5B7-44CA-A0DE-E9B8747E9427 | job → | |
| 2026-08-22 03:21:43.325733 | Info | DataFetch | UrgentAttention | Tanaya.Chimnani@kwglobal.com |
--- Stage 2 begin --- template=UrgentAttention recipient=Tanaya.Chimnani@kwglobal.com userId=92A06C10-1801-4B0F-B83F-BFE93D2C9E39 | job → | |
| 2026-08-22 03:21:43.321730 | Info | Dispatch | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Shashi.Shekharkumar@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='8feeebb5-80dc-4328-950f-d111d681 | job → | |
| 2026-08-22 03:21:43.308726 | Info | Dispatch | UrgentAttention | Shamin.Dsouza@kwglobal.com |
<<< USP_EmailComp_InsertMail returned MailId=cebe320a-e9c0-4708-8409-59ecdacfd2d8 in 34ms (inserted) | 34 | job → |
| 2026-08-22 03:21:43.305726 | Info | Render | UrgentAttention | suresh.pasunkili@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=suresh.pasunkili@kwglobal.com | job → | |
| 2026-08-22 03:21:43.296727 | Info | QA | UrgentAttention | Shashi.Shekharkumar@kwglobal.com |
QA passed (15 check(s)) | 375 | job → |
| 2026-08-22 03:21:43.293730 | Info | Render | UrgentAttention | sumit.emerald@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 151 | job → |
| 2026-08-22 03:21:43.293730 | Info | Dispatch | UrgentAttention | saravankumar.d@kwglobal.com |
Inserted into SentMail. MailId=ee3446b1-c92c-4a25-a88d-e5145d8e49ab | job → | |
| 2026-08-22 03:21:43.280725 | Info | Render | UrgentAttention | suresh.menon@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.268732 | Info | Dispatch | UrgentAttention | Shamin.Dsouza@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='Shamin.Dsouza@kwglobal.com', @Subject='Time Champ: URGENT ATTENTION: Some of your members were not ...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='f75d1d09-69c7-48ab-ac46-f1551dc5f9fb') | job → | |
| 2026-08-22 03:21:43.267727 | Info | QA | UrgentAttention | senthil.b@kwglobal.com |
QA passed (15 check(s)) | 437 | job → |
| 2026-08-22 03:21:43.266730 | Info | Dispatch | UrgentAttention | saravankumar.d@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 2ms | 2 | job → |
| 2026-08-22 03:21:43.261725 | Info | DataFetch | UrgentAttention | suresh.pasunkili@kwglobal.com |
Wrote EmailComp_Job_Data (3088 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 39 | job → |
| 2026-08-22 03:21:43.251730 | Info | Render | UrgentAttention | suresh.menon@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=suresh.menon@kwglobal.com | job → | |
| 2026-08-22 03:21:43.251730 | Info | QA | UrgentAttention | Shamin.Dsouza@kwglobal.com |
QA passed (15 check(s)) | 358 | job → |
| 2026-08-22 03:21:43.250726 | Info | Dispatch | UrgentAttention | saravankumar.d@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=ee3446b1-c92c-4a25-a88d-e5145d8e49ab, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_a0749b6a.xlsx') | job → | |
| 2026-08-22 03:21:43.238724 | Info | Render | UrgentAttention | sumit.gupta@kwglobal.com |
Rendered (17353 bytes, subject='Time Champ: URGENT ATTENTION: Some of your members were not tracked yesterday ( 21-Aug-2026 )', attachments=1) | 150 | job → |
| 2026-08-22 03:21:43.238724 | Info | Dispatch | UrgentAttention | sanjay.singh@kwglobal.com |
Inserted into SentMail. MailId=7d1d50dc-7dec-4ba4-ab81-25d38365407f | job → | |
| 2026-08-22 03:21:43.225724 | Info | Dispatch | UrgentAttention | sanjay.singh@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 21ms | 21 | job → |
| 2026-08-22 03:21:43.212729 | Info | Dispatch | UrgentAttention | seema.balan@kwglobal.com |
Inserted into SentMail. MailId=791afa24-6e5f-44ef-8956-37b52dad948a | job → | |
| 2026-08-22 03:21:43.209727 | Info | Render | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.192723 | Info | DataFetch | UrgentAttention | suresh.pasunkili@kwglobal.com |
UrgentAttention: filtered urgent_cache (1415 rows) by HrUserId=9b624ab5-7e9e-4738-b1f0-db016403d1ad -> 2 row(s) | job → | |
| 2026-08-22 03:21:43.187728 | Info | Dispatch | UrgentAttention | sanjay.singh@kwglobal.com |
>>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=7d1d50dc-7dec-4ba4-ab81-25d38365407f, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/UrgentAttention_2026-08-21_20260822-032143_b670afaa.xlsx') | job → | |
| 2026-08-22 03:21:43.181724 | Info | Render | UrgentAttention | suresh.kalyanaraman@kwglobal.com |
--- Stage 3 begin --- template=UrgentAttention recipient=suresh.kalyanaraman@kwglobal.com | job → | |
| 2026-08-22 03:21:43.173724 | Info | DataFetch | UrgentAttention | suresh.menon@kwglobal.com |
Wrote EmailComp_Job_Data (26874 bytes); shape=dict, top-level=['urgent_rows', 'row_counts'] | 35 | job → |
| 2026-08-22 03:21:43.172725 | Info | Render | UrgentAttention | sumit.emerald@kwglobal.com |
dbo.HtmlTemplates lookup 'UrgentAttentionTemplate': OK (9306 chars, batch-cache hit) | job → | |
| 2026-08-22 03:21:43.169725 | Info | Dispatch | UrgentAttention | seema.balan@kwglobal.com |
<<< USP_EmailComp_InsertMailAttchment OK in 3ms | 3 | job → |