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

• Microsoft Systems Management Server version 1.2

SYMPTOMS

In the Jobs window, System jobs may remain in a Pending state. If you attempt to delete them, the following error message occurs:

Couldn't delete the specified item.
<job id>

CAUSE

This problem can occur when the SQL Server transaction log used by the Systems Management Server database becomes full.

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

Additional query words: prodsms

Keywords : smsdatabase
Version : winnt:1.2
Platform : winnt
Issue type : kbprb