Shrink DBs - Job Script

I'm posting this job script because it gets used by my scheduler script. It simply enumerates through each database on the server, and then executes a DBCC SHRINKDATABASE. The only wrinkle here is that I have it do a quick check to make sure that certain jobs are not already running.

2002-01-04

1,125 reads

Transaction Logs - Job Script

I've included this job script, because it is used by the scheduler scripts that I've also posted. This job is a little more involved than most may need... It first checks to see if certain jobs are running. Is so, it waits for a while, and then checks again. After that it drops the existing […]

2002-01-04

1,085 reads

Check Jobs Current State

I created this script in an attempt to better automate many different jobs that run each morning, as part of a datawarehouse build. I use it to not only tell me what jobs are currently running (so that I can manage how many I would like to run at a time), but what happened to […]

5 (2)

2002-01-03

1,229 reads

Blogs

Getting Started with SQL Prompt 10

By

This week we released SQL Prompt 10, which is an exciting milestone for us....

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Basic courses For Skin Care

By mnbghnmkouad

https takeapills com/gravity-theory-cream/ Gravity Theory Cream

I am new to SQL world

By Kabina

I eager to learn sql , I am currently working on Access . I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers