[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


-----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 2:27 AM
To: 'Dba-Tech (E-mail)'
Subject: Re: [dba-Tech] Scheduled tasks problem

Update on this... I left the PC in question logged on last night, and it
still didn't run. That's a pain... So it looks like it won't run properly
from the task scheduler. I might try it with fewer lines in the batch file,
see if that makes a difference...
 
 
Jon
-----Original Message-----
From: Jon Tydda 
Sent: Thursday, September 28, 2006 10:23 AM
To: Dba-Tech (E-mail)
Subject: Scheduled tasks problem


Hi all
 
I've got a bit of a strange problem with a scheduled task that doesn't run
when it should.
 
It's a batch file which runs various reports from a database, all of which
could potentially take a while, so I have it set to run at 5am every
weekday. I've been unable to get it to run on the db server, so I've got it
running on a client. It works ok when I run it manually when I'm logged in,
but it doesn't when I'm not, despite having unticked the "Run only when
logged in" box and entering a valid account and password. It seems to start
the process, but it doesn't actually run the batch file, by which I mean
that when you look in scheduled tasks it claims to be running, but there's
nothing else happening...
 
I've been running it manually this week, but obviously that's not ideal for
an automated task :-)
 
I'd rather keep the pc logged off if I can help it, as it's the one that's
used for our VPN connection, and not my desktop (I have a different
installation of the DB client on my desktop and it won't work on here).
 
If anyone's got any ideas, I'd be grateful.
 
Thanks
 
 
Jon


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