If this has happened to you recently and you're running Windows 2003 SP 2, you need to check out the following links:

Microsoft Support about SP2 and TCP Chimney

KB Alertz about...

There is no other approach. You can add multiple schedules to a job, but you can't have those schedules run different steps of the job. It's all or nothing.

If you...

Are you doing this from a DVD or a .msi file provided by your corporate IT office?

Use a WHILE loop or a CURSOR on the sp_delete_job command.

The table sysjobhistory contains the columns run_date and run_time. You can use those columns to determine the last time the...

Do the dreaded cursor, and use dynamic sql to throw in the spids, on the "Kill" command.

It's usually efficient and effective, but if any threads are rolling back, nothing...

Really? Funny how small the world is. I spent...

Hey, my dad used to work in that town!

Not very elaborate for a state capital, is it? @=)

The armpit of Florida, Jacksonville.

And, in the spirit of the misconceptions part of this thread:

When my family moved out to Nebraska though (many years ago), some of my fellow...

Glad I could help.

Joy Smith San (3/23/2010)

---

So it's better not to shrink the log unless it's too large.

So that SQL server can use the same space in log and it doesn't have to...

So long as SQL Server does not need any more space for the transactions, it will re-use the current space in the log.

Think of it like this: The transaction log...

Returned to the OS. Freed up for...

See my post on page 1 of this thread. Create a brand new job to run every X number of minutes (however often you want), then pull the data from...

Thanks, Gail. @=)

Ask SSC??? What's the URL to the post? I'm not seeing it in the SQL Server 2005 -> Backups forum.