Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Scheduled launch of query from a PC
 
From:   Rob Paller

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023