VIEWPOINT ALERT

Viewpoint
Teradata Employee

VIEWPOINT ALERT

Hi Everybody,

I'm new with the teradata Viewpoint.

I need to create a Job/alert on viewpoint, that kills a Product Join after a defined processing time!

Is that possible?

Thanks for your help!

Byeeee..


Accepted Solutions
Teradata Employee

Re: VIEWPOINT ALERT

With TASM, you can ensure a query with Product Join & certain elapsed time are executed at a low priority workload or not allowed to execute at all. Once a query has begun execution, TASM offers Exceptions. With Exceptions, you can combine criteria for CPU, Time, Skew, IO etc, yet I believe you cannot combine the same with query characteristics like the presence of a Product Join. 

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: VIEWPOINT ALERT

With TASM, you can ensure a query with Product Join & certain elapsed time are executed at a low priority workload or not allowed to execute at all. Once a query has begun execution, TASM offers Exceptions. With Exceptions, you can combine criteria for CPU, Time, Skew, IO etc, yet I believe you cannot combine the same with query characteristics like the presence of a Product Join. 

Teradata Employee

Re: VIEWPOINT ALERT

I'm sorry to respond a year later!! Smiley Very Happy Smiley LOL
Thank you for the response. That seems working nicely!