Run a query at a particular time

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

Run a query at a particular time

 

Hi All,

 

Is there any way to schedule  a query to run at a particular time in sql assistant.

 

 

Thanks

5 REPLIES
Teradata Employee

Re: Run a query at a particular time

Hi tera_user,

 

There is a Teradata Query Scheduler product :

https://www.info.teradata.com/HTMLPubs/DB_TTU_16_00/index.html#page/General_Reference%2FB035-2029-08...

 

I've never used it though.

You can always write a small batch file and schedule it via cron or windows scheduler.

Teradata Employee

Re: Run a query at a particular time

Note, though, that both SQL Assistant and Query Scheduler are being discontinued. TTU16.20 is the final release for both products.

Enthusiast

Re: Run a query at a particular time

 

Hello Fred,

 

We are currently using teradata 15 so once we move to version 16 then SQL assistent will not be available to us.

Could you please confirm.

 

Thanks.

Enthusiast

Re: Run a query at a particular time

 

Hello Waldar,

 

Thanks for the details.

 

Basically i have to save text bteq script as .BAT file and then run it through windows scheduler at any time.

 

Thanks

 

Teradata Employee

Re: Run a query at a particular time

SQL Assistant is available in Windows client versions through TTU16.20.

And per current policy, TTU16.20 will be supported for queries against Teradata database versions 14.10 through the next two database versions after 16.20 (though there is a possibility that upgrading TTU might be necessary to use some new features).