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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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

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.
Resolution

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.
Defect ID

SOSSE-4282
Attachments

QS_AgentJobsFailed

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title