Thursday, April 18, 2013

DPM 2012 SP1 Scheduled jobs disapear without starting

In this case DPM Server 2012 SP1 installed on Windows server 2012 with remote database on SQL Server 2012 SP1 installed on Windows Server 2012, scheduled jobs for protection groups were disappearing without starting job. Dedicated instance of SQL Server was installed just for DPM 2012 as required. This instance of SQL Server was prepared using DPM Remote SQL Prep. Setup of DPM 2012 SP1 has finished successfully without any issues.
Manually triggering backup was successfully finishing, but scheduled jobs were just disappearing without starting the task.
Following event 208 is logged in application log on SQL Server from source SQLAgent$InstanceName :
The job failed. The Job was invoked by Schedule 13 (Schedule 1). The last step to run was step 1 (Default JobStep).

From Job Activity Monitor can be seen that non-sysadmins have been denied permission to run CmdExec job step:

 
 
SQLAgent for DPM instance was running under Local System account, so adding the sysadmin role to the Local System account has solved the problem.

3 comments:

  1. his is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the excellent work. London Manager opportunity

    ReplyDelete
  2. Very Interested Blog , Happy to looking hope you will put little bit more about that :-) Jobs in Dubai

    ReplyDelete
  3. And Extra thing is , I will Recommend you on Google :-) Thanks for Blog Job Vacnacies in Dubai

    ReplyDelete