Run timer job on a single content database using SPJobLockType.Job

Question

I have developed a custom timer job, inheriting from SPJobDefinition. It currently runs on two content databases, and I would like it to run on only one.

I have created this timer job using the following constructor:

public HiddenTitleJob(string jobName, SPWebApplication webApplication) :
    base(jobName, webApplication, null, SPJobLockType.Job)
{
    this.Title = "Hidden Title Timer Job";
}

Many web sources, including this question, seem to suggest that SPJobLockType.Job prevents my timer job from running on more than one content database, but it hasn't worked for me. Microsoft's documentation is very vague, it only says "Locks the job to prevent it from running on more than one machine" - it says nothing about content databases.

Answer 1

This can only be done by adding code to the Execute method of your timer job, like so:

public override void Execute(Guid contentDbId)
{
    SPSite siteCollection = new SPSite(mySiteCollectionUrl);
    if (siteCollection.ContentDatabase.Id.Equals(contentDbId))
    {
        // timer job code
    }
}

Neither of the three SPJobLockTypes prevent it from running on all content databases for a single web application.

Answer 2

try using

SPJobLockType.ContentDatabase