WMI Alerts

Start a job at a defined step on another sql instance

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.

Simple way to create a SQL Server Job Using T-SQL

Sometimes we have a T-SQL process that we need to run that takes some time to run or we want to run it during idle time on the server. We could create a SQL Agent job manually, but is there any simple way to create a scheduled job?

SQL Server Agent Jobs Statistics

This script will give you a thorough report about sql server jobs based on historical data.

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.

Opportunity for Business Intelligence developer

Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.

Find unused jobs

Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.

Parallel Processing Using Jobs

Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.

List Jobs and their respective programming.

List all active Jobs in SQL Server with the details of the schedule.

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level