SQL Server Scheduled Job fails

Recently our DPM server has been logging the following SQL job error.  This is the DPM dedicated SQL instance and the only SQL installed on this server.  There are no maintenance plans defined, and I couldn't find anything in Task Manager that looked like it related to this.  Can anyone point me to where this job is coming from and why it suddenly started failing?

Log Name:      Application
Source:        SQLAgent$MSDPM2012
Date:          1/21/2014 7:30:04 AM
Event ID:      208
Task Category: Job Engine
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      DPM.internal.com
SQL Server Scheduled Job 'd17d4bf4-ec66-48f2-b4ba-1883dadf5216' (0x5DFD19CBCBB25740B8F242BADA1FA20C) - Status: Failed - Invoked on: 2014-01-21 07:30:00 - Message: The job failed.  The Job was invoked by Schedule 376 (Schedule 1).  The last step to run was step 1 (Default JobStep).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <Provider Name="SQLAgent$MSDPM2012" />
    <EventID Qualifiers="16384">208</EventID>
    <TimeCreated SystemTime="2014-01-21T13:30:04.000000000Z" />
    <Security />
    <Data>2014-01-21 07:30:00</Data>
    <Data>The job failed.  The Job was invoked by Schedule 376 (Schedule 1).  The last step to run was step 1 (Default JobStep).</Data>


January 21st, 2014 8:59am


Is the remote SQL server hosting DPM 2012 or 2012 Sp1 DB's and upgrade or install DPM 2012 R2 that uses the same SQL Server ?

If so DPM2012 R2 SQL Prep overwrites the triggerjob.exe path on remote SQL server for DPM2012 Sp1 and changes the path from %DPMInstall%\Program files\Microsoft Data Protection Manager\DPM2012\SQLPrep to %DPMInstall%\Program files\Microsoft Data Protection Manager\DPM2012R2\SQLPrep. This causes SQL not to be able to find the triggerjob.exe for DPM2012 Sp1 jobs for scheduled jobs to run.

Solution is to re-run the SQLPREP from DPM 2012 Sp1 installation media.

Free Windows Admin Tool Kit Click here and download it now
January 21st, 2014 11:54am


Sorry for the delay in responding.  I think your diagnosis is correct, as I did attempt to upgrade DPM 2012 SP1 to R2 before finding that Windows 2003 is no longer supported.  So I went back to SP1.  My configuration is using the default DPM SQL instance on the local server.  When I tried to run SQLPrepInstall_x64.exe, I got a dialog box saying to run setup.exe.  When I ran setup I found an option for "DPM Remote SQL Prep" but I received an error that "You cannot install DPM Support Files on a computer that has Data Protection Manager."  Is there another way to approach this?



January 28th, 2014 10:44am


SQLPrep is only required for remote sql server hosting DPMDB.

If you re-installed DPM, most likely the path to triggerjob.exe changed.  Look at the properties of a SQL job and look at the path to triggerjob.exe, then make that path and copy the files into it from the new installations bin folder.  Also make sure NTFS permissions are correct and match the new location permissions.

Free Windows Admin Tool Kit Click here and download it now
January 28th, 2014 5:47pm


The two jobs in question point to the correct location for triggerjob.exe.  When I manually run the jobs, they fail just like when they run on the schedule.  There is nothing in the errorlog file or any of the SQL logs.  When I view the Job History, I see the following.  Does this tell you anything?


Date  1/29/2014 7:30:00 AM
Log  Job History (01dfc617-5764-44bc-9b86-e96f64074720)

Step ID  1
Server  DPMVM\MSDPM2012
Job Name  01dfc617-5764-44bc-9b86-e96f64074720
Step Name  Default JobStep
Duration  00:00:02
Sql Severity  0
Sql Message ID  0
Operator Emailed  
Operator Net sent  
Operator Paged  
Retries Attempted  0

Executed as user: DPMVM\MICROSOFT$DPM$Acct. The step did not generate any output.  Process Exit Code -1.  The step failed.

January 29th, 2014 8:37am


If you copy / paste the job step details into an administrative command prompt, does it run or get an error ?

IE: C:\>"C:\Program Files\Microsoft DPM\DPM\bin\TriggerJob.exe" 3d702296-0d68-4e7d-af27-ac7e8a64eac4 93b7d948-5819-4596-b805-2d70e7e268e2 DPMLIB1.contoso.com

Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2014 1:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics