Hi,
I've written a script that checks the status of my mounts.
The best way I found to send summary email at the end was to keep adding data to a variable and then use SEND_MAIL with this variable as it's body. (Script below)
This works fine but I noticed today that I'm getting this error when there appears to be a large amount of data.
The maximum record length of 1023 characters was exceeded.
Is there a way of increasing this value or should I maybe look at doing this a different way?
John.
:SET &MailText# = "These are the remaining hosts with Mount issue&nl# Please Investiage and resolve&nl#":SET &HND2#=PREP_PROCESS_VAR(DBA.BACKUP_MOUNT_RESULTS, ,"0",4)
:PROCESS &HND2#
: SET &DB_HOST# = GET_PROCESS_LINE(&HND2#,2)
: SET &BACKDIR# = GET_PROCESS_LINE(&HND2#,4)
: SET &PROD_DB_NAME# = GET_PROCESS_LINE(&HND2#,6)
: SET &MailText# = "&MailText#&nl# &DB_HOST# with mount &BACKDIR# on Database &PROD_DB_NAME# &nl# "