Solved

Batch File to run all vbscripts in a folder

Posted on 2014-03-04
12
536 Views
Last Modified: 2014-03-05
I have an ever growing number of vbscripts that I set up scheduled tasks to run every 15 minutes and there's got to be a better way.  Is there a way to put together a batch file that will run every script in a particular folder?  That way I could just have one scheduled task to rule them all!  

Thanks in advance.
0
Comment
Question by:kingbc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 3
  • +1
12 Comments
 
LVL 69

Assisted Solution

by:Qlemo
Qlemo earned 333 total points
ID: 39905005
Of course. e.g. with a cmd batch file:
@echo off
for %%F in (C:\Scripts\*.vbs) do cscript //nologo %%F

Open in new window

0
 
LVL 13

Expert Comment

by:Santosh Gupta
ID: 39905015
forfiles /p D:\scripts\ /m *.vbs /c "cmd /c wscript @file"
0
 
LVL 43

Accepted Solution

by:
Steve Knight earned 167 total points
ID: 39905025
And if they can run at the same time you can do something like:

@echo off
for %%F in (C:\Scripts\*.vbs) do START ""  "cscript //nologo %%F"

And to make sure they run in a particular order use a dir command, e.g.

@echo off
cd /d c:\scripts
for /f "tokens=*" %%F in ('dir /b /a-d /o-d *.vbs') do cscript //nologo "%%~F"

That would do the newest first (/o-d), oldest first is /od
/on is alphanumeric filename order etc. i.e. name then 01-script.vbs, 02-something.vbs etc. or A_script.vbs, B_Script.vbs

etc.

Steve
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 69

Expert Comment

by:Qlemo
ID: 39905064
In regard of "in a particular order", usually you ascertain that by prefixing each file name with e.g. a two-digit number, ascending, and then use the DIR as shown above.
0
 

Author Comment

by:kingbc
ID: 39905506
Sounds like this should be straight forward yet I'm getting an error.  

"windows cannot find "cscript //nologo d:\scripts\file1.vbs......."
even though this file and others are in that location.

What am I missing?
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 39905551
Please post your code.  are there spaces in the path or filenames?  Have you tried with suitable " " around the paths like in my last example?

Steve
0
 

Author Comment

by:kingbc
ID: 39906997
Thanks Steve
Below is the code.  The contents of the folder get interated as expected as the error messages shows as much;

---------------------------------------
The system cannot find the file cscript //nologo C:\Users\bking\Documents\Scripts\EnvMon\Tasks\file1.vbs.
The system cannot find the file cscript //nologo C:\Users\bking\Documents\Scripts\EnvMon\Tasks\file2.vbs.
The system cannot find the file cscript //nologo C:\Users\bking\Documents\Scripts\EnvMon\Tasks\file3.vbs.

----------------------------------------
Exit code: 1 , 0001h

@echo off
for %%F in (C:\Users\bking\Documents\Scripts\EnvMon\Tasks\*.vbs) do START "" "cscript //nologo %%F"

Open in new window

0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 39907071
on mobile at mo, but try syntax suggested in my last post using di and "" around filename.

Steve
0
 
LVL 69

Assisted Solution

by:Qlemo
Qlemo earned 333 total points
ID: 39907090
If using Steve's suggestion, we have to modify that a bit:
@echo off
for %%F in (C:\Users\bking\Documents\Scripts\EnvMon\Tasks\*.vbs) do START "" cscript //nologo "%%~F"

Open in new window

0
 

Author Comment

by:kingbc
ID: 39907160
Deleting the quotes around the cscript //nologo %%F section did the trick.  Problem solved, points to be shared since both dragon-it and qlemo provided essentially the same solution.  Thanks to all!
0
 

Author Closing Comment

by:kingbc
ID: 39907169
Thanks to Steve (dragon-it) for the fast response times on my questions!
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 39907244
No problem, glad it helped.

Steve
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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