Archives of the TeradataForum

Message Posted: Wed, 28 Nov 2001 @ 13:39:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If I recall correctly, Windows 2000 should have a some type of built in scheduler that you may be able to take advantage of with Queryman and its startup parameters. Windows NT 4 had a utility called 'AT', located in the WINNT\SYSTEM32\ folder. The AT utility combined with Queryman, a SQL Script file and you should be all set to fire off a scheduled query from your PC.

This will require that you create a User DSN that stores the userid and password so that when you use the '-c' startup parameter with Queryman you are not prompted for userid and password. This is obviously not very secure, but will get the job done.

Regards,

Rob

	<Prev	Next>		<<First	<Prev	Next>	Last>>