Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] How to schedule a job in Windows

Hi all,
Have an issue when scheduling a job in a batch file using Windows Scheduler. I have 5 jobs that are in my batch file. When I execute the batch from Windows it works, when Windows Scheduler executes it, it works too. The mystery I have is when I open a job in the repository (without making any changes) the next time the batch is kicked off by Windows Scheduler, it doesn't run. Anyone know why?
Also, if I do make a change to a job that is in my batch file, it will not run either, even though the patch is still the same. Any ideas how to update a job in the respository and not have to update the batch file each time?
Here's my batch file:
"C:/Program Files/Java/jre6/bin/java.exe" -Xms256M -Xmx1024M -cp C:/TOS-Win32-r20205-V3.0.2/lib/java/jtds-1.2.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/ojdbc14-10g.jar;C:/TOS-Win32-r20205-V3.0.2/workspace/.Java/classes;C:/TOS-Win32-r20205-V3.0.2/lib/java; medicalert.paymentmethodlookup_0_1.PaymentMethodLookup --context=Default
"C:/Program Files/Java/jre6/bin/java.exe" -Xms256M -Xmx1024M -cp C:/TOS-Win32-r20205-V3.0.2/lib/java/jtds-1.2.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/ojdbc14-10g.jar;C:/TOS-Win32-r20205-V3.0.2/workspace/.Java/classes;C:/TOS-Win32-r20205-V3.0.2/lib/java; medicalert.sponsorslookup_0_1.SponsorsLookup --context=Default
"C:/Program Files/Java/jre6/bin/java.exe" -Xms256M -Xmx1024M -cp C:/TOS-Win32-r20205-V3.0.2/lib/java/advancedPersistentLookupLib.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/commons-collections-3.2.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/jtds-1.2.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/ojdbc14-10g.jar;C:/TOS-Win32-r20205-V3.0.2/workspace/.Java/classes;C:/TOS-Win32-r20205-V3.0.2/lib/java; medicalert.influencerdim_0_1.InfluencerDim --context=Default
"C:/Program Files/Java/jre6/bin/java.exe" -Xms256M -Xmx1024M -cp C:/TOS-Win32-r20205-V3.0.2/lib/java/ojdbc14-10g.jar;C:/TOS-Win32-r20205-V3.0.2/workspace/.Java/classes;C:/TOS-Win32-r20205-V3.0.2/lib/java; medicalert.membersdim_0_1.MembersDim --context=Default
"C:/Program Files/Java/jre6/bin/java.exe" -Xms256M -Xmx1024M -cp C:/TOS-Win32-r20205-V3.0.2/lib/java/advancedPersistentLookupLib.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/commons-collections-3.2.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/jxl.jar;C:/TOS-Win32-r20205-V3.0.2/lib/java/ojdbc14-10g.jar;C:/TOS-Win32-r20205-V3.0.2/workspace/.Java/classes;C:/TOS-Win32-r20205-V3.0.2/lib/java; medicalert.member_states_dim_0_2.member_states_dim --context=Default
Labels (4)
20 Replies
Anonymous
Not applicable
Author

hi is it possible to set the automatic time to run this job.. suppose dialy evening 5 o clock the job should run automatically and the excel values should store into database