Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maryxu
Starting Member
36 Posts |
 Posted - 2008-03-19 : 16:47:04
|
| I have those errors Invalid object name 'msdb..sysJobs'.=========================================================================the error comes from the query select count(*) from msdb..sysJobs j, msdb..sysjobschedules s where j.enabled = 1 and j.job_id = s.job_idI run the query on same servers with sysjobs, everything is fine. But why sysJobs can't be accepted? so strange, any idea please? thank you |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-03-20 : 12:59:23
|
| What version of SQL are the servers that raise the errors running? This will work for SQL2K but I believe that the table names changed for 2005.Terry |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-03-20 : 14:23:31
|
| On the general tab of your db properties what collation are you using. I wonder if you're hitting a case sensitivity issue.Mike"oh, that monkey is going to pay" |
|
|
|
maryxu
Starting Member
36 Posts |
Posted - 2008-03-20 : 17:21:29
|
you are right, thank youquote:
Originally posted by mfemenel
On the general tab of your db properties what collation are you using. I wonder if you're hitting a case sensitivity issue.Mike"oh, that monkey is going to pay"
|
|
|
|
|
|
|
strange error