[dba-Tech] Scheduled tasks problem

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



More information about the dba-Tech mailing list