Kill the scheduled job

sonali_panda
Giga Expert

‎10-20-2017 03:33 AM

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

  • 7,585 Views
12 REPLIES 12

Chuck Tomasi
Tera Patron

‎10-20-2017 06:53 AM

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.)


Preview file
61 KB
Preview file
126 KB

peg612
Kilo Expert
In response to Chuck Tomasi

‎03-21-2018 10:41 AM

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? 

 

Chuck Tomasi
Tera Patron
In response to peg612

‎03-22-2018 05:14 AM

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.

0 Helpfuls