SQL Server Performance

Getting Error 207 When trying to view Job properti

Discussion in 'SQL Server DTS-Related Questions' started by cnauricej, Nov 23, 2005.

  1. cnauricej New Member

    I have created and schedule a DTS package. However, if I go to Jobs and try to right-click to view the properties, I get a series of error messages.

    Error message box #1 states:
    Error 207: Invalid column name 'performance_condition'. Invalid column name 'job_id'.

    Error message box #2 states:
    The requested operation cannot be performed because of invalid internal values.

    I am unable to view any of the properties associated with the job. This is now happening for ALL scheduled jobs.

    Any ideas on how to resolve are greately appreciated. Thanx.
    cnauricej, Nov 23, 2005
    #2

  2. cnauricej New Member

    So no one has any ideas??? <img src='/community/emoticons/emotion-6.gif' alt=':(' />
    cnauricej, Dec 9, 2005
    #2

  3. satya Moderator

    What is the service pack level on SQL Server?
    How about privileges for SQL Agent on this server?

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 12, 2005
    #2

  4. cnauricej New Member

    This is SQL 2000 SP 4. As for privileges, I was running the job as SA.
    cnauricej, Dec 13, 2005
    #2

  5. dirtydavey New Member

    did u ever figure this out?

    I have the same problem now
    dirtydavey, May 30, 2007
    #2

  6. satya Moderator

    Explain bit more on the significance of this job.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, May 30, 2007
    #2

Share This Page