Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Jan 2012 @ 16:30:34 GMT


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


Subj:   Not getting email notification
 
From:   JAMES PARK

Teradata V13 on Windows Server 2003.

I created a macro in TD Administrator to generate a weekly report on database space. Then I created this .bat file and a config and script file.Then I created a Scheduled task to run this bat file.

I see that the log file and dbfreespace file in tmp folder are generated. But I don't get email notification from GroupWise email. The scheduled task produces 0x1. The result should be 0x0.

     @echo off
     ::--------------------------------------------------------------
     :: Weekly report on MaxPerm, CurrentPerm and freespace of all
     :: databases.
     ::--------------------------------------------------------------
     set
     TSTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%_%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
     set TFILE=..\tmp\dbfreespace.txt

     call ..\config\setenv_dba.bat
     bteq ".logon %TDLOGON%" < ..\scripts\Rpt_dbfreespace.btq >
     ..\logs\Rpt_dbfreespace_%TSTAMP%.log 2>&1

     C:\DWAPP\dev\bin\mpack -s "DEV Database Freespace Report" -c application/text ^  -o
     ..\tmp\dbfreespace.mim %TFILE%

     C:\DWAPP\dev\bin\bmail -s abcd1 -t myemail@xxxx.xxxxx.xx.xx ^ -f
     "dba@xxxxxxxxxx.xxxx.xxxxx.xx.xx" ^ -a "DEV Database Freespace Report" -m
     ..\tmp\dbfreespace.mim

Thank you,



     
  <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