SMS: Can't Delete Systems Jobs That Are in a Pending State

WORKAROUND

Before deleting the pending system jobs, first correct the problem with the transaction log and ensure that a backup has been made of the SMS database.

To delete these jobs, use a SQL Server query. To do this, perform the following steps:

1. Use ISQL/w to execute the following SQL Server query:

   Select * from Jobs where JobType = null

2. Verify that the jobs listed are all "Pending" system jobs. If necessary, you can print the list of job IDs and compare the list in the Systems Management Server Administrator program.
3. Execute the following query to delete the jobs:

   Delete from Jobs where JobType = null

This procedure should remove all of the system jobs that have a Pending state.