SQL Server Performance Forum – Threads Archive
Getting Error 207 When trying to view Job properti
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.
So no one has any ideas??? <img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />
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.
This is SQL 2000 SP 4. As for privileges, I was running the job as SA.
did u ever figure this out? I have the same problem now
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.
]]>