A couple of months ago I was working on a CRM installation when I noticed an Event Log message that was similar to the following:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/18/2006
Time: 7:00:01 AM
User: N/A
Computer: SERVER
Description:
SQL Server Scheduled Job 'Start_Incremental on Company_Name_Inc__MSCRM.ftcat_documentindex.[7.5]' (0×00000000000000000000000000000000) - Status: Failed - Invoked on: 2006-08-18 07:00:01 - Message: The job failed. The Job was invoked by Schedule 41 (Indexed Document Title Schedule). The last step to run was step 1 (Full-Text Indexing).

 

We had come into the customer after another partner had installed and removed CRM. It turns out that the above message was caused by an artifact left over from the previous installation.

 

During installation, the installation program will replace any invalid characters in the Organization Name with an underscore, and used that modified name for creating the databases and other items within SQL.

 

The initial installation was created with the Organization Name of "Company Name Inc." which was converted to "Company_Name_Inc_" when the SQL objects were created.

My installation was created with "Company Name Inc" which translated into "Company_Name_Inc".

Somewhere along the line, one of the CRM maintenance tasks was left running from the previous installation. Since the database it worked against no longer existed, it generated a warning each time it attempted to start.

The solution was to locate the improper task and delete it, using the following steps:

( Assuming SQL 2000 )

  1. Open SQL Server Enterprise Manager
  2. Expand Management
  3. Expand SQL Server Agent
  4. Click on Jobs
  5. The Job that contains an Organizational Name that doesn't match the Organization Name in the other Jobs needs to be deleted