Kill the scheduled job
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Labels:
-
Best Practices
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2017 06:53 AM
Go to System Diagnostics> Active Transactions (All Nodes)
Look for your running active transaction and right-click on it and select "Kill".
If it is somehow marked uncancelable, you'll have to open the record and use the Force Kill button (as per the instructions displayed.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.