Scheduling a Task to Run Once every 6months using AT Command and VBScript

I currently have the code below that removes and old task on my XP machines and adds a new and if Vista is the OS detected it skips the removal portion and simply adds a task. This works well and dandy my only issue is the scheduling portion.

I currently have it set in the code so it scans on the 28th of each month. However I'd only like it to scan once every 6 months so If I could select only January and June I'd be happy, however I cannot seem to find how to schedule a task like this to only run on the 28th of the two months I want.

Can anyone offer me some advise on how to do this or if it's possible?


Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2")
Set colOperatingSystems = objWMIService.ExecQuery ("SELECT * FROM Win32_OperatingSystem")
For each objOperatingSystem in colOperatingSystems 
 
If left(ObjOperatingSystem.version,1) >=6 Then 
Call Add_Job
Else
    strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
 
Set objInstance = objWMIService.Get("Win32_ScheduledJob.JobID=1")
 
err = objInstance.Delete
 
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set objNewJob = objWMIService.Get("Win32_ScheduledJob")
errJobCreated = objNewJob.Create _
     ("c:\Progra~1\Identi~1\IdentityFinder.exe /jobmode /inifile=\\SERVERADDRESS\idf$\ini\cph.ini"  , "********000000.000000-420", _
        True ,  , 134217728 , , JobID=1)
 
 
End If
Next
 
 
Sub Add_Job()
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set objNewJob = objWMIService.Get("Win32_ScheduledJob")
errJobCreated = objNewJob.Create _
    ("c:\Progra~1\Identi~1\IdentityFinder.exe /jobmode /inifile=\\SERVERADDRESS\idf$\ini\cph.ini"  , "****06**000000.000000-420", _
        True ,  ,134217728 , , JobID=1)
End Sub

Open in new window

lotharpenguinAsked:
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.

MikeKaneCommented:
Good question.   I went searching for this one, I looked at both the AT command as you requested and also at the Win32_scheduledJob Class.    

In each case you can not specify a date for the scheduled item.  Each will only accept a weekday, or day of the month.  

Looking at the msdn:
http://msdn.microsoft.com/en-us/library/aa394399(VS.85).aspx

Quote on the STARTTIME:
UTC time to run the job, in the form of "YYYYMMDDHHMMSS.MMMMMM(+-)OOO", where "YYYYMMDD" must be replaced by "********". The replacement is necessary because the scheduling service only allows jobs to be configured to run one time, or run on a day of the month or week. A job cannot be run on a specific date.

Basically, doesn't look like you can do this via script.
0
lotharpenguinAuthor Commented:
^^ That's what I had found also. But it makes no sense since you can choose a month in the task scheduler itself.
0
MikeKaneCommented:
It must be early or I would have thought of this before....  

Try using the shell command schtasks  instead of AT or the Win32_scheduledJob Class.

the schtasks /create has a /MO option to specify weeks of the year numbered 1-52.   That should take care of your issue.  

Sample:
Set objShell = Wscript.CreateObject("Wscript.Shell")
objShell.run("cmd /c schtasks.exe /create /SC DAILY /ST 15:00:00 /TN Backup /RU domain_name\user ID /RP password /TR c:\backup.vbs")

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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

lotharpenguinAuthor Commented:
For some reason I think I had tried that in the past and there was an issue with the UNC path or something I shall try it again and see what happens.
0
lotharpenguinAuthor Commented:
Yep with the list of switches I have to use with the app to get it to do what I need it to do schtask bawks at me and fails to add the job in the script. Outside of the script it functions but written as such.

It assumes /jobmode is a switch on schtasks not the IDF application.

Set objShell = Wscript.CreateObject("Wscript.Shell")
objShell.run("cmd /c schtasks.exe /create /SC MONTHLY /ST 15:00:00 /TN IDF /TR c:\Progra~1\Identi~1\IdentityFinder.exe /jobmode /inifile=\\ph-home.public-health.uiowa.edu\idf$\ini\cph.ini ")

Open in new window

0
MikeKaneCommented:
Here's a workaround:

Create 1 batch file with the line,
c:\Progra~1\Identi~1\IdentityFinder.exe /jobmode /inifile=\\ph-home.public-health.uiowa.edu\idf$\ini\cph.ini

Then use the schtask to call the batch file.....  

0
lotharpenguinAuthor Commented:
^^ Yep decided to just use a vbscript to call my scheduled command in a .bat file. Seems to work ok and is now scheduled for JUN and JAN 1st. Thanks Mike!
0
lotharpenguinAuthor Commented:
Great help on this subject.
0
lotharpenguinAuthor Commented:
In case anyone needs to do something like this in the future:


#VBS FILE TO CALL BAT FILE AND ELIMINATE VISTA BOXES FOR ERROR ISSUES:
 
On Error Resume Next
Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2")
Set colOperatingSystems = objWMIService.ExecQuery ("SELECT * FROM Win32_OperatingSystem")
For each objOperatingSystem in colOperatingSystems 
 
If left(ObjOperatingSystem.version,1) >=6 Then 
Call Add_Job
Else
    strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
 
Set objInstance = objWMIService.Get("Win32_ScheduledJob.JobID=1")
 
err = objInstance.Delete
 
Set oShell = CreateObject("WSCript.shell") 
 
sCmd = "\\BATFILELOCATION\schtask.bat"
oShell.Run sCmd, 0, False
 
End If
Next
 
Sub Add_Job()
Set oShell = CreateObject("WSCript.shell") 
 
sCmd = "BATFILELOCATION\schtask.bat"
oShell.Run sCmd, 0, False
End Sub
 
 
#BAT FILE CONTENTS:
 
cmd /c schtasks.exe /create /SC MONTHLY /m JUN,JAN /ST 15:00:00 /TN IDF /TR "c:\Progra~1\Identi~1\IdentityFinder.exe /jobmode"

Open in new window

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
VB Script

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.