Jon Tydda
Jon.Tydda at alcontrol.co.uk
Fri Sep 29 04:26:31 CDT 2006
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