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 |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-04-30 : 07:22:02
|
| Hi... I have a problem with msdb.dbo.sysjobhistory table . Actually i was created trigger (for Insert ) for this table because i need to capture when ever job gets completed that jobs should insert into my personal table. the main problem here i am able to capture into my personal table , but from the main table msdb.dbo.sysjobhistory data is deleting . What is the reason behind that. -->is there any problem for creating the trigger.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-04-30 : 07:38:22
|
First please do a right click on SQL Server Agent in SSMS-Object-Explorer and have a look at the properties / settings for "History".Maybe then you can see a reason why some rows are missinig...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2012-04-30 : 08:14:53
|
| Thank you ... webfred .Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Sysjobhistory is deleted