Solved

Windows 2003 server software or tool to stop and start a scheduled tasks if they hang

Posted on 2011-03-21
6
318 Views
Last Modified: 2012-05-11
Hi,

We have some scheduled tasks set to run on a server that are database import/export related. To cut a long story short the database and scheduled tasks are written by a 3rd party, who don't see any issues with the jobs.  Problem is these jobs just stop from time to time and need to be restarted. Once restarted the jobs run fine, but the 3rd party doesn't want to investigate - support is currently being looked at but this still needs to happen.

All that said the jobs simply need to be restarted, and I am looking for some software or a tool that we can use to moitor these jobs and restart them if they are running for longer than 15 minutes.  Would be fine to do this manually, but this tends to happen around 5:00 - 7:00am in the morning.

Anyway if someone knows of a piece of software or a tool to sort this out let me know.  

Thanks,
Dave

 
0
Comment
Question by:biggles70
  • 4
6 Comments
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 35185128
You might want to look at GFI MAX Remote Management - it can monitor the server and restart a service if it is stopped if that is what you want it to do.

Great bit of software!

http://www.gfi.com/it-managed-services-software
0
 
LVL 24

Expert Comment

by:lionelmm
ID: 35188596
How are the tasks run? Automated in the 3rd party software or via Windows scheduled tasks?
0
 

Author Comment

by:biggles70
ID: 35194514
They tasks are run using Windows scheduled tasks. The tasks actually run a 3rd party vendor exe file which has switches and an input file.

Just looking for something cheap/free and only for one server.  
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 24

Expert Comment

by:lionelmm
ID: 35197765
You can setup scheduled tasks so that they terminate after a certain amount of time--it seems you know that it should not run for more than a certain amount of time. In the Settings tab in Scheduled tasks is an option to control that. I also suggest you use a batch file to start the task and have the batch file check for the successful file for that day--the import/export file--I assume it is unique every day (if not let me know and I can give you another suggestion of what to check for). As such, the batch file will first check for today's file--if it exists it will exit if it does not it will call or start the import/export. To make sure that the task does complete successfully setup the tasks to repeat. Assuming it takes the task 10 minutes to import/export setup the task to repeat every 20 minutes for 1 hour (or whatever you want)--this can be done in the Schedule section of Scheduled tasks and click on the advanced button. So what you end up with is a scheduled tasks that runs at a certain time by batch file--it looks for a successful file--if it finds it it quits, but if not run the import/export--if it runs for more than 10 minutes it will be stopped, but then again in 20 minutes the task will run again and go through the same process--that way if it is not successful it can try however many times you decide it set it up as to re-try. The only problem I see is that Windows Scheduled Tasks may not be able to stop the import/export but only the batch file. Will this work for you--if not let me know and I can come with other ideas/suggestions.
0
 
LVL 24

Expert Comment

by:lionelmm
ID: 35197781
Another question--if you run the import/export successfully and then try to run it again will it know it was previously run successfully and simply not do anything? If yes, then bag my batch file idea and setup the import/export application with the repeat and terminate options.
0
 
LVL 24

Accepted Solution

by:
lionelmm earned 500 total points
ID: 35339170
I put quite a bit of time into this and gave my best options and solutions but without giving me further feedback the user is now wanting to close the question. Not sure if what I suggested would work or not because user did not give me further feedback or information. As such I should get the points for trying to help even though user did not respond to my latest suggestions.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now