Voltar
-
Título
Agent Jobs Failed Internal error -
Descrição
Spotlight is reporting the following error: Severity Alarm Message Raised Cleared Information Monitored Server - SQL Server Collection Execution Failure Collection 'Agent Jobs Failed Internal' failed : Insert Error: Column name or number of supplied values does not match table definition. All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists.... -
Resolução
verify if the connection in question is a SQL Server 2000 instance.As we did significant changes to the agent job (failure) collection and don't support SQL Server 2000 any longer as it is not supported by Microsoft either.