Archives of the TeradataForum

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

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

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

Thank you,

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