InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 21 Mar 2010 08:49:39 GMT20http://www.sqlservercentral.com/Forums/Topic747334-338-1.aspxDuplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlservercentral.com/Forums/Topic747333-338-1.aspx[/url]Sun, 05 Jul 2009 06:09:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic747334-338-1.aspxHIHOQ CAN I MEASURE THE PERFORMANCE OF A JOB>?I HAVE A JOB WITH ONE STEP AND IN THIS JOB I LOAP TO THE ROWS IN THE TABLE AND checking the time of each row if it is more than a value so i will delete this row and update a field in other tablei want to find a way to check the performance of my job for 100000 record and to know when this record will be deleted and the delay which it take the job to be deletedI WANT A WAY TO KNOW HOW TO MEASURE PERFORMANCE I USE NOW SQL SERVER 2008 WHICH TYPE OF THE ALERT WILL HELP MEAND IF I WANT TO CREATE A JOB DUNAMICALLY HOW CAN I DO ITSun, 05 Jul 2009 05:55:47 GMTmai_tbaileh