Jon Tydda
Jon.Tydda at alcontrol.co.uk
Fri Sep 29 08:46:45 CDT 2006
Yep, here's a sample of it... REM Update Jobs \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" RSLTCALC \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" CUSTOM UPDATEJOBS REM Files used by several tables. \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA WORK CHROM \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA SAMPLES Active Samples \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA TESTS TESTS_CHROM \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA WORK PREP \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA WORK WETCHEM \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA TESTS TESTS_WETCHEM \\ALCAISLG1\AISLIMS\AISLIMS\AIS32.EXE /INI="D:\AIS32JT.INI" EXPORTDATA DETS DETS_PREP After that, there's a lot more exporting going on, to set up various work lists for the analysts. This is the batch file that doesn't work. It runs when you double click it, but not when scheduled. REM For Daily Disposal Reports c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_Haz_S, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_S, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_L, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_Haz_W, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_W, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_CUST01, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_CUST02, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_CUST03, Disposal List, F c:\AISLIMS\AIS32.EXE /INI="C:\AIS32JT.INI" ReportSamples Disposal_AQC, Disposal List, F Jon -----Original Message----- From: Beach Access Software [mailto:bchacc at san.rr.com] Sent: Friday, September 29, 2006 2:42 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Scheduled tasks problem The 32 command job on the server is in a batch file? Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jon Tydda Sent: Friday, September 29, 2006 6:18 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Scheduled tasks problem Yes. I managed to get it working by scheduling each report separately rather than all 8 in a batch file. It's odd as I have a similar one on the server which runs 32 different commands one after the other, but no dice here. Jon -----Original Message----- From: Beach Access Software [mailto:bchacc at san.rr.com] Sent: Friday, September 29, 2006 2:16 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Scheduled tasks problem Are you using Windows scheduler? Rocky The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291