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 |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2010-05-13 : 05:21:07
|
| Hi All,I am working on generating job report for all version of sql servers.In my query i am using msdb..sysjobactivity that has a session_id column and need this columns to find out the max sql agent session like this : select max(session_id) from msdb..sysjobactivitywhen i create my procedure on sql 2005 version or above version it works bcaz the table is exists but in case of sql 2000 and below it does not work .Could any one please suggest me which table is equivalent in sql 2000Thanks Vijay Sahu |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-05-17 : 09:41:07
|
| Does msdb..sysjobhistory work?Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
 |
|
|
|
|
|
Equivalent table in sql 2000