Re: Is there a simple tool to shedule sql-query's on windows

#1

Quote:

I've been looking for a simple tool to shedule (complex) sql-query's which
run's
on windows and uses ODBC. Output to .csv format or some other simple
format.
The logon has to happen directly before the query's and thus automatic.

For example : It should be possible to run several query's at 6.50 am
every
morning mo-vr and other -very long- query's during the weekend.

Is there something like that available?

The at command and a batch file should do it.

In a DOS box, type "at/?" for details.

#2

Hi

On Mon, 28 Jul 2003 17:24:43 +0100, "programmer"
<int.consultNOCAPITALS (AT) macmail (DOT) com> wrote:

Quote:

I've been looking for a simple tool to shedule (complex) sql-query's which
run's
on windows and uses ODBC. Output to .csv format or some other simple
format.
The logon has to happen directly before the query's and thus automatic.

For example : It should be possible to run several query's at 6.50 am
every
morning mo-vr and other -very long- query's during the weekend.

Is there something like that available?

The at command and a batch file should do it.

In a DOS box, type "at/?" for details.

Yes I know, but I'm looking after something more "user-friendly"
and more integrated. Maybe with a seperate
frontend configuration tool.

Alain

#3

Alain schrieb:

Quote:

Hi

On Mon, 28 Jul 2003 17:24:43 +0100, "programmer"
int.consultNOCAPITALS (AT) macmail (DOT) com> wrote:

I've been looking for a simple tool to shedule (complex) sql-query's which

run's

on windows and uses ODBC. Output to .csv format or some other simple

format.

The logon has to happen directly before the query's and thus automatic.

For example : It should be possible to run several query's at 6.50 am

every

morning mo-vr and other -very long- query's during the weekend.

Is there something like that available?

The at command and a batch file should do it.

In a DOS box, type "at/?" for details.

Yes I know, but I'm looking after something more "user-friendly"
and more integrated. Maybe with a seperate
frontend configuration tool.

Alain

Windows comes with a graphical frontend for the AT tasks.
Its located in the control panel, and is called scheduled tasks.

Thomas

#4

We use a product called Schedule Wizard. Very powerful, easy to use, and not
expensive. More info located at http://www.authord.com/SW/

"Alain" <7h295001 (AT) sneakemail (DOT) com> wrote

Quote:

Hi

I've been looking for a simple tool to shedule (complex) sql-query's which
run's
on windows and uses ODBC. Output to .csv format or some other simple
format.
The logon has to happen directly before the query's and thus automatic.

For example : It should be possible to run several query's at 6.50 am
every
morning mo-vr and other -very long- query's during the weekend.

Is there something like that available?

Alain

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Is there a simple tool to shedule sql-query's on windows

comp.databases comp.databases

Re: Is there a simple tool to shedule sql-query's on windows - 07-28-2003 , 11:24 AM

Re: Is there a simple tool to shedule sql-query's on windows - 07-28-2003 , 11:53 AM

Re: Is there a simple tool to shedule sql-query's on windows - 07-28-2003 , 12:12 PM

Re: Is there a simple tool to shedule sql-query's on windows - 07-29-2003 , 02:13 PM