265
Does anyone know where is the system job for CRM 2016 Goals Rollup Calculation stored in database?
I noticed the CRM system job default Goal rollup job is missing. I am exploring on how to add it back and auto run it.
*This post is locked for comments
I was able to re-create the Goal Rollup Job by runing this query:
exec sp_executesql N'insert into [AsyncOperationBase]([OwningBusinessUnit], [DependencyToken], [OperationType], [StateCode], [RecurrencePattern], [Data], [OwnerIdType], [CorrelationId], [RecurrenceStartTime], [TimeZoneRuleVersionNumber], [CreatedBy], [MessageName], [OwnerId], [Depth], [CorrelationUpdatedTime], [ModifiedBy], [ModifiedOnBehalfBy], [AsyncOperationId], [Subtype], [ModifiedOn], [CreatedOn], [Name], [StatusCode]) values (@OwningBusinessUnit0, NULL, @OperationType0, @StateCode0, @RecurrencePattern0, NULL, @OwnerIdType0, @CorrelationId0, @RecurrenceStartTime0, @TimeZoneRuleVersionNumber0, @CreatedBy0, NULL, @OwnerId0, @Depth0, @CorrelationUpdatedTime0, @ModifiedBy0, NULL, @AsyncOperationId0, @Subtype0, @ModifiedOn0, @CreatedOn0, @Name0, @StatusCode0)',N'@AsyncOperationId0 uniqueidentifier,@OwningBusinessUnit0 uniqueidentifier,@OperationType0 int,@StateCode0 int,@RecurrencePattern0 nvarchar(200),@OwnerIdType0 int,@CorrelationId0 uniqueidentifier,@RecurrenceStartTime0 datetime,@TimeZoneRuleVersionNumber0 int,@CreatedBy0 uniqueidentifier,@OwnerId0 uniqueidentifier,@Depth0 int,@CorrelationUpdatedTime0 datetime,@ModifiedBy0 uniqueidentifier,@Subtype0 int,@ModifiedOn0 datetime,@CreatedOn0 datetime,@Name0 nvarchar(200),@StatusCode0 int',@AsyncOperationId0='4D1D25D5-8A71-4E31-BAB5-D1866147E5DB',@OwningBusinessUnit0='FILL WITH YOUR MAIN BUSINESS ID',@OperationType0=40,@StateCode0=0,@RecurrencePattern0=N'FREQ=DAILY',@OwnerIdType0=8,@CorrelationId0='0D2B727E-361F-4AD3-8FE5-6E9A21550CF7',@RecurrenceStartTime0='2017-03-30 14:00:00',@TimeZoneRuleVersionNumber0=0,@CreatedBy0='SYSTEM USER ID',@OwnerId0='SYSTEM USER ID',@Depth0=0,@CorrelationUpdatedTime0='2017-03-30 14:00:00',@ModifiedBy0='SYSTEM USER ID',@Subtype0=1,@ModifiedOn0='2017-03-30 14:00:00',@CreatedOn0='2017-03-30 14:00:00',@Name0=N'Goal Rollup job',@StatusCode0=0
Any update on this issue?
I experience the same issue on my CRM 2016.
Thank you!
Can you go to any goal and click on recalculate, you might be able to get it back.
Usually, you cannot delete goal system job as it is required by the system. Even if you click on delete, system will throw an error.
I dont know, How you managed to delete it; if recalculation of Goals does not generate a new job, please contact Microsoft support, they might help you to restore it.
Hi Steve,
Please change the view to "Recurring Jobs". You can find the "Goal Roll-up Job" in that list.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (