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-12 : 05:44:38
|
| Hi experts ,Can anyone tell me how can i get the job log from the database.Why i am asking this becaz i dont have access to log file so that i can not the the log in file .Is their any procedure which could tell the current job log? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-05-12 : 06:58:21
|
select * from msdb.dbo.sysjobhistory
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
how to get job log