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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2008-08-12 : 09:18:41
|
| Am I joining these tables correctly? I need to get the schedule information for specific jobs across all the servers. SELECT ...FROM msdb.dbo.sysjobs a INNER JOIN msdb.dbo.sysjobschedules b on a.job_id=b.job_idINNER JOIN msdb.dbo.sysschedules c on b.schedule_id=b.schedule_id---http://www.ssisdude.blogspot.com/ |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-12 : 16:58:17
|
What does Books Online tell you about those tables?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Joining sys tables