i just found this fella on the net

maybe it would help you

http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

to be honest this is the first time im benefiting from CDC , and i discovered it yesterday. I said DB trigger because i just simply saw it under...

Thanx for the advices GSquared,

Fortunately the client is interested only in updated values. And i agree that i dont need new value so im writing this down as a ...

Hey guys,

Thanks for the advices but i just did it in my way 🙂 and i think this is worth sharing with our world( and beyond :P) .

Scenario:

Using sql server...

No guys ,

Im having a graeat time in my office today .. the sun is shining , and no one bothered me till now 😀

Thanks you've...

Mike01 (5/11/2011)

---

I tried it and I get the error "Value of 125 is not valid for value. V alue should be between Minimum and Maximum Parameter name" When I...

ninja, thanks !!!

im so happy that i could eat a whole lamb right now ..

i think we shold report this as a QOS requirement to Microsoft..

It...

well ninja,

commands complete succesfully , and when i expand the job in Agent tab i can se the schedule is there .. as soon as i want to...

HMM , i hoped it would work but... ney !

125 is out of range 🙁

thanks chris ! its much faster now .. considering that this table im working on has 11000000 rows right now .. and grows more every minute 🙂