Arvind Singh
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 <> [...]
Posts Tagged ‘SQL’
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
2
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 <> [...]
