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.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Calculate SQL Job Execution Time

Author  Topic  learntsql 524 Posts Posted - 2010-02-13 : 00:44:12 Hi... I am Using SQL server 2005 and configured Few SQL Jobs, Some run in business hours and some are in non-business hours. How to Calculate the total execution time, CPU and memory Utilization of each job? Any Optimization techniques for SQL Jobs? TIA.