Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1716
  • Last Modified:

SQL AGENT JOB FAILED

This a new DMZ server doing migration side by side. I moved all my jobs to this server and Audit Eval Trace come back failed with the following report: Could not create a trace file. [SQLSTATE 42000] (Error 19062)  Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070003(The system cannot find the path specified.). [SQLSTATE 01000] (Error 19097).  The step failed.
I am also getting error in full backup job : The step did not generate any output.  Process Exit Code 1.  The step failed.
0
kenny56
Asked:
kenny56
2 Solutions
 
tanujchandnaCommented:
Hi,

Apply MSSQL service pack SP1/SP2 and after that problem should go away for you.
0
 
VENKAT KOKULLASQL Server DBACommented:
Please go through the below link.

Let us know whether the issue is cleared r not..!

http://support.microsoft.com/kb/195566
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now