Arvind Singh
1. If any of the job’s status has changed from “Publishing” to “Unpublished”, most likely there are exceptions that caused the job to fail. a. Run the SQL script to understand the cause USE Microsoft_MSCRM GO SELECT Name, ErrorCode, Message, * FROM AsyncOperation WHERE OperationType = 7 ORDER BY CompletedOn DESC Message column should contain [...]
Archive for the ‘SQL’ Category
Troubleshooting Microsoft CRM Asynchronous process jobs
Posted: September 10, 2010 in Microsoft Dynamics CRM, SQLTags: Asynchronous, Asynchronous Job types, Asynchronous Jobs, Troubleshooting Asynchronous Jobs, Workflow
0
Delete log and rebuild index of AsyncOperationBase and WorkflowLogBase table in Dynamics CRM using SQL Job
Posted: September 9, 2010 in Microsoft Dynamics CRM, SQLTags: AsyncOperationBase, Delete log, Microsoft, RebuildIndex, SQL, SQL Job, WorkflowLogBase
USE [msdb] GO /****** Object: Job [Async-CleanUP] Script Date: 05/27/2010 12:36:09 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 05/27/2010 12:36:09 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’[Uncategorized (Local)]‘ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’[Uncategorized (Local)]‘ IF (@@ERROR <> [...]
Update database statistics everyday
Posted: September 9, 2010 in Microsoft Dynamics CRM, SQL, SQL ServerTags: Database, SQL, Statistics, Update, Update Statistics
USE [msdb] GO /****** Object: Job [Data_Update_statistics_everyday] Script Date: 05/27/2010 12:32:03 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object: JobCategory [Database Maintenance] Script Date: 05/27/2010 12:32:03 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’Database Maintenance’ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’Database Maintenance’ IF (@@ERROR <> [...]
Rebuild Index of a database table
Posted: September 9, 2010 in Microsoft Dynamics CRM, SQL, SQL ServerTags: Rebuild, RebuildIndex, RebuildIndex of a Table, SQL Server
DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 CREATE Table #databaseName (dbid int identity(1,1), DbName Varchar(255)) Insert into #databaseName SELECT name FROM MASTER.dbo.sysdatabases – WHERE name NOT IN ( ‘master’, ‘model’, ‘msdb’, ‘tempdb’, ‘distrbution’ ) WHERE name IN ( ‘OD’) ORDER BY 1 CREATE Table #TableName (Tableid [...]
