How to make plans complete from back end

This is for RB 2.x

Plan status is stored mainly on below 3 tables

select * from Plans where id='plan id'

select * from AsRunPlans where id='plan id'

select * from AsRunSteps where PlanId='plan id' order by EndDate desc

*****

1st we need to check if the plan has any incomplete steps and make them complete.

update AsRunSteps set StartedDate='2026-01-24 11:55:14.0000000 +00:00',EndDate='2026-01-24 12:53:14.0000000 +00:00',ExecutionStatus=4

where id='StepID'

2nd update the Asrunplan table

update AsRunPlans set AsRunPlanStatus=103,EndDate='2026-01-25 21:25:35.0000000 +00:00' where id='Planid'

3rd Update the Plan table

update Plans set Status=10 where id='Planid'

****Please run it with utmost care**** Have another team member verifying what you are executing.