Technical Article

Scheduler SP with Sample Log Creation/Exec Scripts

I created this SP for use with our morning DW builds. I use it to manage the execution of multiple jobs. It first starts up to a configureable number of jobs, monitors these jobs until one (or more) complete, and then starts additional jobs as needed. If any jobs fail, it will run the "transaction […]

You rated this post out of 5. Change rating

2002-01-06

219 reads

Technical Article

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.

You rated this post out of 5. Change rating

2002-01-04

1,147 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2002-01-04

1,099 reads

Technical Article

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)

You rated this post out of 5. Change rating

2002-01-03

1,260 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Need help on query within 2 column, generate another column

By Adelia

Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...

SELECT blocking DML and DDL

By vsamantha35

Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...

query filling up tempdb

By vsamantha35

Hi All, Need some help in tune a function which is reading TB's of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers