Transform job does not run as per schedule. The job status shows always in not started status. If we run the job manually, it runs successfully without errors. Reports does not show latest data.

Hello folks,

 

I wanted share my experience while troubleshooting one of the SCSM 2012 R2 transform job issue.

Issue :  

Transform job was not running as per schedule. The job status was showing always in 'not started' status. If we run the job manually, it was running successfully without errors.  No reports showing latest data. 

Resolution :

  • There was no job failure errors for transform job on the DW management server event logs.
  • Checked the last 5 number of batches and it was showing as completed. But the batch number for transform job was having huge difference compared to other job batches.
  • Tried running the ETL jobs manually and it ran successfully for all the jobs. No errors. It catch up the latest batches.
  • The report started showing latest data.
  • Found the following errors related to the transform job Scheduler Data Source Module.
  • Checked the job status using get-scdwjob and get-scdwjobschedule, both were showing as enabled for transform job.

 ===========================================================

Log Name: Operations Manager 

Source: Health Service Modules
Date: <Date>

Event ID: 11366

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: <ComputerName>

Description:

The Microsoft Operations Manager Scheduler Data Source Module failed to initialize because some window has no day of the week set.

One or more workflows were affected by this.   

Workflow name: Schedule_Transform.Common

Instance name: ?????????

Instance ID: {37FECB60-26C5-FCDC-950D-F24CE13C3DF6}

Management group: <ManagementGroupName>

===========================================================

  • Checked the schedule for all the jobs using get-scdwjobschedule and found that the 'Frequency' column value was missing in the output. It supposed to show '0:30' as per the default schedule. 

Transform.Common                         Daily    17/03/2015 06:00:00      True         <Frequency>       18/03/2015 11:20:00

  • Added the following schedule for transform.common job using cmdlet. 

Set-SCDWJobSchedule -JobName Transform.Common -ScheduleType Daily –DailyFrequency 00:30:00 –DailyStart 12:00

  • The transform job schedule started automatically after this change. 

 

 

 

Thanks

Santosh Killekar - Support Escalation Engineer (Microsoft System Center)

Disclaimer: This posting is provided "AS IS" with no warranties and confers no rights.