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,081 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
817 reads
By Steve Jones
As we try to get through these strange times in the world, I am...
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I hope someone can help. I will try to summarise as best as...
I work on sql server I need to rewrite statement after where statement so...
Hi Everyone. I'm hoping someone can take a look at my code here to...
Ask SSC