Jimmie's Sharings

Not all timer jobs are visible in the Central Administration timer job definition page. There are MOSS 2007 timer jobs in the SSP application which don’t appear in the Central Administration page. It makes sense that these jobs are not visible, since there is nothing you can modify or disable. All the same, it would be nice to know what these jobs are, and what their schedules are, in case you want to schedule other potentially conflicting activities.

You can see the names of these SSP jobs by using stsadm enumssptimerjobs command, as in the following console sample:

>stsadm -o enumssptimerjobs -title SharedServices1

SSP Timer Job Id="3c289b1f-83d7-471d-a872-1f9edb32dca0" Display Name="Distribution List Import Job"

SSP Timer Job Id="b78e2f0c-237e-4483-8a4c-34de2db0e8b2" Display Name="Audience Compilation Job"

SSP Timer Job Id="513ccf0f-35a1-4f42-a905-974644f7e5fd" Display Name="User Profile Incremental Import Job"

SSP Timer Job Id="802204e6-443b-4beb-94f2-a920ce1e393d" Display Name="User Profile Full Import Job"

SSP Timer Job Id="8b882c4f-f806-4149-9fed-ac4e8873c0a5" Display Name="User Profile Change Cleanup Job"

SSP Timer Job Id="3d05f298-98f4-46c0-b905-bd4cb2894e39" Display Name="User Profile Change Job"

This display unfortunately does not give the job schedule. The job definitions are held in the SSP database, specifically in the MIPScheduledJob table. IMPORTANT CAVEAT: direct access to any MOSS database is officially unsupported; however, a simple query is all that is needed to look at the interesting columns in this table. Under no circumstances should you attempt to modify this table. Doing any modification to the database will cause your MOSS installation to become unsupported.

With the warning behind us, how can we query this table? First we need to know the SSP database name. You can get this from the SSP Edit page in Central Administration. In the following picture the SSP Database is named SharedServices1_DB, and it is on the MOSS database server.

Use SQL Server management studio or other query tool to submit the following query:

SELECT DisplayName, Recurrence, NextDueTime, Disabled

FROM MIPScheduledJob

The result will look like the following table.  Now we can see the schedule, next time to run, and the disabled status. Note the disabled jobs are not truly disabled. They are explicitly run by other SSP features; primarily the User Profile import. Now that you know the built-in job schedule, you can schedule any custom activities affecting user profiles and audiences outside these times.

.