06-14-2016 04:39 AM
Hello, does anyone know where in SQL I can locate references to archiving task runs selected by Run ID? I've a bunch of scheduled archiving tasks listed on an archiving report with the status of Running, but they have start times of 4 months ago. I double checked no archiving was going on with a quick DTrace with tasks started and stopped so I know there's no archiving going on, but I don't know where I can find these task jobs listed in SQL so I can kill them and have my archiving reports look neat and tidy again! Any ideas?
Solved! Go to Solution.
06-20-2016 06:18 AM
Hello Gertjan, thanks for the link. I ended up logging this one with support and it turns out the solution to this is as follows:
Task status is determiend by an XML in the report folder itself called RunInfo.xml. If you edit the file in Notepad you'll see a status value of 0 which should in fact be 2. Update this status code, save the file and refresh the IE report page, and voila
<?xml version="1.0" encoding="UTF-16" ?><Information><Status>0</Status>
Update like:
<?xml version="1.0" encoding="UTF-16" ?><Information><Status>2</Status>
06-14-2016 11:21 PM
Just remove the offending folders. (or move them somewhere else)
06-20-2016 06:18 AM
Hello Gertjan, thanks for the link. I ended up logging this one with support and it turns out the solution to this is as follows:
Task status is determiend by an XML in the report folder itself called RunInfo.xml. If you edit the file in Notepad you'll see a status value of 0 which should in fact be 2. Update this status code, save the file and refresh the IE report page, and voila
<?xml version="1.0" encoding="UTF-16" ?><Information><Status>0</Status>
Update like:
<?xml version="1.0" encoding="UTF-16" ?><Information><Status>2</Status>
06-20-2016 11:30 PM
Great, thanks for letting us know.