Beach Access Software
bchacc at san.rr.com
Fri Sep 29 08:41:52 CDT 2006
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 -----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 _______________________________________________ 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