[dba-Tech] Scheduled tasks problem

Jon Tydda Jon.Tydda at alcontrol.co.uk
Fri Sep 29 09:10:02 CDT 2006


Yeah, just seems odd that a longer, more involved one works, and this
doesn't. Oh well. Next hurdle is to make it work at 5am on Monday morning...


Jon

-----Original Message-----
From: Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Friday, September 29, 2006 3:07 PM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Scheduled tasks problem


Well, if it's working now with separate calls, that's where I usually stop.
But if you're curious, I suppose you could try combining two calls into a
batch then adding more calls every night to see which one is causing the
batch to fail.  

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:47 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Scheduled tasks problem

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
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006
 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com


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