VBA: monitor Windows Schedule task

Hello experts,

I have multiple Windows shedule task in one of my server. I was wondering how I can see the status, and last execution of  the various shedule task in an Excel Worksheet. The idea is to run the macro locally and  display in a Worksheet schedule task information.

Thank you again for your help.
LVL 1
LD16Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
I'm a huge fan of NirSoft's (free!) utilities, which I've been using for many years:
http://www.nirsoft.net/

One of them is TaskSchedulerView:
http://www.nirsoft.net/utils/task_scheduler_view.html

Scroll to the bottom of the page at the above URL for the download links. Note that there are both 32-bit and 64-bit versions. It is a no-install/stand-alone executable — just unzip the file and run the EXE.

When you run it, the main window shows all of the scheduled tasks:

TSV main
The View>Choose Columns menu lets you select the fields that you want to see:

TSV columns
Then View>HTML Report - All Items creates an HTML file that loads beautifully in into Excel:

TSV report in Excel
It wasn't clear from your question if you want to see the tasks just on your server or on other computers, too. If the latter, then read the section called Connecting Remote Computer, which says, "TaskSchedulerView also allows you to view and disable/enabled the tasks of a remote computer, as long as you have permission to do that." Note, also, that there is a command line capability, which allows you to view "This computer" or a "Remote computer". You could easily make a call to the command line in a batch file or other script/program to achieve just about whatever you want - and schedule it to run daily or as often as you want. Regards, Joe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LD16Author Commented:
Thank you very much for your comment.

The idea is to monitor  windows schedule tasks of a remote server from my computer so I will use the Connecting Remote Computer.
I have some questions:
1-Calling connection Remote computer can damage the performance of my remote server?I supposed that no but I would like to be sure.
2- Why you mention that I could easily make a call the command line? Should I do this to refresh the data retrieve by Task Scheduler view? Calling Connection remote computer is not enough to display in real-time windows schedule tasks, status etc of my remote server?

Thank you again for your help.
0
Joe Winograd, Fellow&MVEDeveloperCommented:
> Calling connection Remote computer can damage the performance of my remote server?

Executing TaskSchedulerView.exe with the Remote Computer option is not going to degrade the performance of the remote server. Sure, it will take some cycles to retrieve the data and send it, but that should be just a blip.

> Why you mention that I could easily make a call the command line? Should I do this to refresh the data retrieve by Task Scheduler view?

Yes, exactly. I would write a batch file (or script or program or whatever you're comfortable with) to call the command line and then schedule that every so often (perhaps once an hour) via the Task Scheduler on your computer.

> Calling Connection remote computer is not enough to display in real-time windows schedule tasks, status etc of my remote server?

Yes, it displays it in real-time, but it is not constantly refreshing the data — there's a Refresh button on the toolbar. I suppose you could simply leave it running on your computer and click the Refresh button whenever you want to see the current data, but my thinking is to run it periodically via the Task Scheduler on your computer and use one of the Save options (text, CSV, HTML, XML, etc.) to save the data in a file. Regards, Joe
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.