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 […]
