Killing the active tasks in CSI

This entry was posted in Uncategorized on

Following are important scripts

Select * from ActiveBGTasks where createdate > Cast (GetDate() as date) and TaskStatusCode = ‘READY’

Delete from ActiveBGTasks where createdate > Cast (GetDate() as date) and TaskStatusCode = ‘READY’

Select * from bgtaskhistory where createdate > Cast (GetDate() as date) and CompletionDate is null and TaskExecutable =’ConsolidatedInvoicingLaser_xxx’
]
Delete from bgtaskhistory where createdate > Cast (GetDate() as date) and CompletionDate is null and TaskExecutable =’ConsolidatedInvoicingLaser_xxx’

Comments

comments