Solved

SQL AGENT JOB FAILED

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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