Kill the scheduled job

sonali_panda
Giga Expert

Hi All

We have a scheduled job running which has to delete records from task table. It needs to delete 400000 records. Its deleting only 20K per day.

Because of the scheduled job, instance has become slow.

We want to run the scheduled job during the non business hours.

Is it possible to kill the scheduled job automctically when we business hours starts. lets say it starts at 8 am, Can we kill the scheduled job automatically.

Manually we can but is it possible to automate that.

Thanks

Sonali

12 REPLIES 12

Chuck Tomasi
Tera Patron

Go to System Diagnostics> Active Transactions (All Nodes)


find_real_file.png



Look for your running active transaction and right-click on it and select "Kill".


find_real_file.png



If it is somehow marked uncancelable, you'll have to open the record and use the Force Kill button (as per the instructions displayed.)


Hi Chuck,

Is there a way to determine which transaction belongs to a scheduled job? For example, it shows 4 scheduled jobs running a minute apart and we need to kill one. How do we determine which one is the one we are looking to kill? 

 

I believe you could look at stats.do and get the transaction ID there. I haven't checked recently and don't have an instant way to test this. 

Go to the navigation filter on the upper left and type stats.do and check the output. somewhere in there it should show your scheduled jobs running and (hopefully) a transaction ID nearby. That's the plan.