This script gives you an idea on how long the processing time is for your SQL jobs. It will depend on how many records are being retained on the sysjobhistory table (scripts defaults to the last 30 days--may not find any history at all).One may find it useful when there are so many sql jobs […]
2003-02-06
4,346 reads
This script list all SQL Server Jobs with schedule details. One will not need to go to the enterprise manager and verify each job properties just to get the scheduled frequency for each job.
2003-01-31
861 reads
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...
We get a sql connection from host informatica server and the query runs in...
I am trying to write a query to get a list of all SQL...
Ask SSC