Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Apr 2014 @ 15:18:20 GMT


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


Subj:   Set up alert using BTEQ with ViewPoint
 
From:   JAMES PARK

TD 14 on SLES 11. BAR server is Windows.

I am trying to figure out how to set up alert through BTEQ with ViewPoint. Below is what I got from VP Alert manual.

Step 1 says, "1 Copy the BTEQ script cpuUsageReport.txt to the Windows server at:

InstallFolder\Teradata\Client\14.10\Teradata Notification Service \sql."


I am trying to find a server where Teradata Notification Service is installed.

1. It just says 'Windows server". It doesn't tell which Windows server. Does it mean a database server or BAR server or any other server?

2. What could be that 'InstallFolder'?


Thanks,



Example: BTEQ Script

In this example, we run a BTEQ script as an alert action for the Teradata Database system TEST1, weeknights only, and track alerts in the Alert Viewer portlet. The BTEQ script, cpuUsageReport.txt contains the following macro that returns a problem analysis of daily workloads: EXECUTE ResPmaTotal;.

1 Copy the BTEQ script cpuUsageReport.txt to the Windows server at:

          InstallFolder\Teradata\Client\14.10\Teradata Notification Service \sql.

2 Verify that the Teradata Notification Service is running on the Windows server.

a At the Windows command prompt, type services.msc.

b Check that the status for the Teradata Notification Service is started in the list of services.


James Park
Database Specialist



     
  <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: 27 Dec 2016