I have a SQL Server 2008 SP3, I have an agent job that ran successfully for last the month, however as of yesterday it keeps failing error is below.
Executed as user: Domain\Account. File '' either does not exist or is not a recognizable trace file. Or there was an error opening the file. [SQLSTATE 42000] (Error 567). The step failed.
Here is the error message from log to table & included step output in history Msg 567, Sev 16, State 5, Line 23:
File '' either does not exist or is not a recognizable trace file. Or there was an error opening the file. [SQLSTATE 42000]
DECLARE @trc_path VARCHAR(500), @message VARCHAR(MAX), @message1 VARCHAR(MAX), @textdata VARCHAR(1000) SELECT @trc_path=CONVERT(VARCHAR(500),value) FROM fn_trace_getinfo(DEFAULT) WHERE property=2 INSERT INTO #temp_cfg SELECT TEXTData, HostName, ApplicationName, DatabaseName, LoginName, SPID, StartTime, EventSequence FROM fn_trace_gettable(@trc_path,1) fn WHERE TEXTData LIKE '%configure%' AND SPID<>@@spid AND fn.EventSequence NOT IN (SELECT EventSequence FROM SQLConfig_Changes) AND TEXTData NOT LIKE '%Insert into #temp_cfg%' ORDER BY StartTime DESC