SQL Server Trying to Run a Job That DOES NOT Exist

  • Hi Folks

    more issues again with jobs.

    this time SQL Server is trying to run a job that does not exist on a database that does not exist and I cannot find the job

    Any help would be appreciated

    Thanks

    Jim

    Errors:

    [000] Failed to retrieve job 0x8CE2E78061B5BB4D81D7AFE21BEDF754 from the server

    [000] Failed to retrieve job 0x52FA741E8D8D7A4296DC041FCF0B9381 from the server

    [000] Failed to retrieve job 0x2C8D1C49AEDA384EB5866C6C45E327C3 from the serve

    use [msdb];

    go

    select

    CAST (name as varchar(60)) as job_name,

    job_id,

    enabled

    from

    sysjobs

    order by

    name;

    go

    job_name job_id enabled

    ------------------------------------------------------------ ------------------------------------ -------

    CDW_NSAB-SS80-SQL-N_NSAB-SS80-SQL-N_0 B757E5BD-00B6-49B6-AE9A-909C0C373FDF 1

    CDW_NSAB-SS80-SQL-N_NSAB-SS80-SQL-N_1 8CBD9BF7-A27B-4ADB-BE4F-541DF4D30D7C 1

    CDW_NSAB-SS80-SQL-N_NSAB-SS80-SQL-N_2 6D5D5CEB-07F7-4844-90D2-1C7C22123E11 1

    CDW_NSAB-SS80-SQL-N_NSAB-SS80-SQL-N_3 96AA561C-3A29-456B-A524-C59CDC7C571D 1

    Event Task Cleanup SS67_VirtualCenter 0A5BBC42-D467-40BC-9D5F-CD43A725801E 1

    MP-FullBackup-UserDB.Subplan_1 C8FE6DFD-E571-467E-9369-A43DECCDB3D5 1

    Past Day stats rollupSS67_VirtualCenter 98529A3A-1CD7-42C8-B8E6-43A740E037A9 1

    Past Month stats rollupSS67_VirtualCenter 99FBE6A3-CAE4-4A68-9700-069AEE541786 1

    Past Week stats rollupSS67_VirtualCenter 82EE019E-1509-437F-9E8D-D0C26278E404 1

    QA_SharedServices1_DB_Job_DeleteExpiredSessions 6E87BC49-C2CD-4E8F-B2A8-6F1470BD10CC 1

    SP04_SharedServices1_DB_Job_DeleteExpiredSessions D1F4CC7F-6CF1-489E-BBCF-363A6BF15CC2 1

    SS62_SharedServices1_DB_Job_DeleteExpiredSessions 5A7898C7-B647-416B-AAF5-B6A0A1A7425B 1

    SS63_SharedServices1_DB_Job_DeleteExpiredSessions 044B9E97-39AE-467C-B74C-7B9E58BABD2F 1

    SS70_SharedServices1_DB_Job_DeleteExpiredSessions B361ADB6-F093-4AA2-B78E-F54DD57DC5BD 1

    SS80-MP-Archive-Databases-Full.Subplan_1 5D13C8E1-F14C-4642-9A78-C86D602563DD 1

    SS80-MP-DB-Rebuild-Indexes.Subplan_1 52700929-4A61-44B8-8AB0-C0821B76F0A7 1

    SS80-MP-Maintenance-Cleanup.Subplan_1 CA421D46-E4DF-4CC2-A5C0-53A3EC53F668 1

    SS80-MP-SampleDB-Backup-Full.Subplan_1 8DC59092-F46F-4B86-9A85-B25C65040809 1

    SS80-MP-SystemDB-Backup-Diff.Subplan_1 C375A93E-557E-4457-8D84-DB2DF886EDD4 1

    SS80-MP-SystemDB-Backup-Full.Subplan_1 C3EFE692-76EE-414D-8D11-44CEB9BAA18F 1

    SS80-MP-SystemDB-Maintenance-Stats.Subplan_1 78CD1C07-8AB2-4D20-A256-9F55305E7C83 1

    SS80-MP-UserDB-Backup-Diff.Subplan_1 703221A0-452C-49F1-8D83-86BDCBA3E8CE 1

    SS80-MP-UserDB-Backup-Full.Subplan_1 A528E976-1043-4AA3-B871-4829F711409D 1

    SS80-MP-UserDB-Backup-Trans.Subplan_1 7776A4A2-EB1E-4093-968E-DA7C9B2F6955 1

    TfsActivityLogging Administration Job 3DF1A060-4EBB-4C01-BD94-E47CF376CC38 1

    TfsBuild Team Build Administration Job 8C143948-CDF5-425C-95AD-5990286B13BB 1

    TfsIntegration Maintenance Job FEF33DAF-7003-4F41-B539-161381EA2711 1

    TfsVersionControl Administration Job 5DB18470-62E2-4200-9819-708236F60752 1

    TfsVersionControl Hourly Job 4E4D065D-A829-4F61-A6E8-89AED98BE28A 1

    TfsWorkItemTracking Full Text Crawl Job 4B0BB03C-45FF-43A7-A197-CF295975DC09 1

    TfsWorkItemTracking Process Identities Job 534EE535-F5F1-4697-ACB6-EF345E95E697 1

    Topn past day SS67_VirtualCenter 5BA6E16C-1D55-4B61-B3B4-E1921753FA88 1

    Topn past month SS67_VirtualCenter AF09E656-42BD-4519-944D-53F951165064 1

    Topn past week SS67_VirtualCenter 2B65DAF5-77EF-4E30-826B-D06C91F3975F 1

    Topn past year SS67_VirtualCenter A05DE957-097C-4028-AFB0-14564FB594A3 1

    X_MP-Backup-Full-SSXX_Databases.Subplan_1 F7EA2D3D-21D4-4641-8C89-B717F0AB818B 1

    X_MP-SystemDB-Backup-Trans.Subplan_1 70664BAD-3356-4934-9B12-BECDD16CC5D7 1

    X_MP-Test-2.Subplan_1 EC8ABE1F-A7ED-4CE7-A47B-200B1B3056A1 0

    X_MP-UserDB-Backup-Full-SingleDatabase.Subplan_1 91F81C8E-B2A0-4FFA-B091-84A9E41954BD 1

    X_MP-UserDB-Maintenance-Stats.Subplan_1 CA51BBF2-1B58-4351-A3C2-9ED37BB2EF21 1

  • By chance is the mystery job actually associated with a old Maintenance Plan?

    Check that Job ID against the sysmaintplan_subplans table

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Hi Chris

    some more info

    database in question was deleted on 6-3-11

    job(s) associated with database were deleted on 7-11-11

    errors ocurred on 7-12-11

    errors have not ocurred since

    there are no such entries under these tables

    sysjobs

    sysmaintplan_subplans

    sysmaintplan_log

    i see that these jobs begin with "0x" and i do not see any other jobs that begin with that combination

    so i do not know if that is significant or not

    Thanks for the Assist

    Jim

  • Do you have sysadmin privileges on the server? I m just giving a guess in case you don't have permissions !

  • sure do ssismaddy

    since i have not seen the error in three days, maybe it cleaned itself up 🙂

    Jim

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply