Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Not getting email notification

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 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 [email protected] ^ -f
     "[email protected]" ^ -a "DEV Database Freespace Report" -m

Thank you,

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