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_id
I 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
Sounds like you have a case sensitive collation on that server. I suggest
always using the actual case and not creating your own punctuation for these
objects, for exactly this reason.
Also, I strongly recommend getting out of the bad habit of writing old-style
joins. The proper, more modern, more standard, and more readable query
would be:
SELECT COUNT(*)
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobschedules s
ON j.job_id = s.job_id
WHERE j.enabled = 1;
>I have those errors Invalid object name 'msdb..sysJobs'.
> =========================================================================
[quoted text clipped - 4 lines]
> I 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