Solved

SQL AGENT JOB FAILED

Posted on 2011-09-21
2
1,652 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
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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