SQL_MonitorJobs does not generate detail message in Action_SMTPMail email message. (NETIQKB54336)

  • Document ID:7754336
  • Creation Date:02-Feb-2007
  • Modified Date:21-Jan-2011
    • Micro Focus Products:
      AppManager

Environment

AppManager 6.0.x
AppManager for Microsoft SQL Server 6.2
SQL_MonitorJobs Knowledge Script

Situation

SQL_MonitorJobs does not generate detail message in Action_SMTPMail email message.

Cannot see some information about the job.

Resolution

This was fixed with the 6.4.12.0 version of the SQL module. Please install the latest SQL module to resolve this issue.

Cause

The detail message information returned from SQL_MonitorJobs uses XML for formatting.  The XML code used has different names for the columns in the column definitions and the rows.  This difference causes the Action_SMTPMail script to see the columns but not the rows.  With the rows missing no data beyond the title of the table is returned and the email generated by Action_SMTPMail does not contain the event detail information.

Additional Information

Formerly known as NETIQKB54336