Solved

SQL AGENT JOB FAILED

Posted on 2011-09-21
2
1,669 Views
Last Modified: 2012-05-12
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
Comment
Question by:kenny56
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
tanujchandna earned 250 total points
ID: 36584867
Hi,

Apply MSSQL service pack SP1/SP2 and after that problem should go away for you.
0
 
LVL 5

Assisted Solution

by:VENKAT KOKULLA
VENKAT KOKULLA earned 250 total points
ID: 36716288
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question