Instead we just keep packages and configs on a fileshare and execute them using SQL jobs. The only constraint this imposes is that we use windows authentication on our connections....

I belong to something like 40 websites; financial, gaming, social networking, community (like this one). I use a password vault for most of these which makes it a little easier...

Thanks guys. It looks like having our server support team recycle the SQL Agent service did the trick. All jobs are running through their entire schedules.

Ken

Found it, thanks.

SELECT databaseid, filename, SUM(IntegerData*8) AS 'Growth in KB', Duration, StartTime

FROM fn_trace_gettable(<your trace file>, DEFAULT)

WHERE EventClass BETWEEN 92 AND 93

GROUP BY databaseid, filename, IntegerData, Duration, StartTime

ORDER BY...

Years ago the company I worked for would patch the majority of our servers one Friday night each month. The Microsoft patches for the month, and other software patches, would...

I'm in NJ but our company is spread out with...

Truth is, this machine is flakey. Maybe it's tempdb. It was setup by another group with way too many files, 16 on an 8 core box. We've been trying to...

Thanks Lowell. That is some out of the box thinking!

Ken

Thanks, not seeing much in the logs. I'm tempted to let the data drive fill up just to see what happens :-D. But our end user folks would be going...

Tom, thanks for sharing this. Not sure what you did to prevent that annoying @schedule_uid from appearing in the new job (which would cause it not to compile) but I'm...

Yeah, I was going to say, I'm overwriting the backup each time with INIT. So as you say the tranlog contains either the 1st set of deletions or the last,...

Thanks folks, and thanks for the article!

Ken

Nice. I use this:

SELECT jobs.name AS 'JobName',

sched.name AS 'SchedName',

CASE sched.freq_type

WHEN 4 THEN 'Daily'

WHEN 8 THEN 'Weekly'

WHEN 16 THEN 'Monthly'

WHEN 32...

Same here, which is why I'm...

I'm with CrankyRat on this one. Maybe not the Glenn Beck part 🙂 In the last 10-12 years here in the USA we've seen internet bubbles, mortgage meltdowns, and financial...