Error while monitoring instance: "Agent Jobs Failed Internal failed sysdatetime is not a recognized built-in function.” (4275748)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Error while monitoring instance: "Agent Jobs Failed Internal failed sysdatetime is not a recognized built-in function.”
Beschreibung

User keeps receiving a Monitored Server error "Agent Jobs Failed Internal failed sysdatetime is not a recognized built-in function". This is only happening on our SQL 2005 versions - Standard and Enterprise.
Lösung

WORKAROUND:
Obtain attached patch and follow below step to apply:
1. Locate <Diagnostic Server installation folder>\Agent\conf\Package\sqlserver_spotlight\2005\
2. Find QS_AgentJobsFailed.sql in the folder and take a backup of
3. Replace it by the attached file.

STATUS:
Waiting for fix in future release of Spotlight on SQL Server Enterprise.
Fehler-ID

SOSSE-4282
Anhänge

QS_AgentJobsFailed

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel