sql 2000 backup schedules, dts schedules - where stored

Question

sql 2000 backup schedules, dts schedules - where stored

Barkingdog

SSCoach

Points: 18670
More actions
May 22, 2007 at 4:02 pm

#68416

Which table(s) in sql 2000 hold the date\time when the sql agent jobs ran? Same quesiotn for DTS jobs. (I need "view" only access to this info.)
Barkingdog

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

My System Table Map doesn't show anything for DTS, but the agent tables are in msdb. A quick search of BOL will tell what tables you need to look at.

happycat59 One Orange Chip Points: 29451 More actions · Answer 2

DTS packages are scheduled using SQL Server Agent.

The tables you need to look at are sysjobs and sysjobschedules (both in MSDB).

You may find sp_help_job and sp_help_jobschedule useful as well.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

Here is a handy limk no DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Barkingdog SSCoach Points: 18670 More actions · Answer 4

Rudy,

What a great link! I was totally unaware of it. Do you know fo one for sql 2005 also?

Bill

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 5

There is one for 2005 but it is a PDF document .... in my opinion MS blew it for DBA usability and scored on marketing 'fluff' ... here is the link ...

http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Barkingdog SSCoach Points: 18670 More actions · Answer 6

Thanks Rudy. I agree that MS blew it with the pdf format. CHM is much more useable.

Barkingdog