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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 08:06:34
|
| Suresh writes "Hello,I'm fairly new to the MS SQLserver world. Currently we've got some jobs scheduled in the database which are executed by the Microsoft SQL Server Agent.I need to write a monitoring tool that will report on the following : -Log shippingJobs Clashing between one another job - another job starts before the first job has completed.Jobs QueuingDelayed Jobs SQL job profiler - History of activity (eg) For log shipping, build a job profile on start and finish times of each log ship completed; the time of execution of each job against volume; and time of execution against duration of job. and the amount of volumn and compare the duration itself.I would appreciate any assistance since I need to complete this by the end of next week." |
|
|
MuadDBA
628 Posts |
Posted - 2004-06-08 : 09:18:13
|
| LMAO. |
 |
|
|
|
|
|
Monitoring jobs scheduled via Microsoft SQL Server Agent