Self Scheduling Jobs

Jobs with a calcuable run date can self schedule themselves.

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.

Job Summary

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.

UP_COMPACTA_COPIA

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.

SQL Server Agent job information

Find all Job Relationships with SSIS Config files

Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.

Scheduling Jobs for Random / Multiple Dates

I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...

Custom sp_start_job to delay next task until SQL Agent Job has completed

The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn't wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another job or task that depends on the result of the previous job.

View to obtain Failed Jobs from SQL Server Agent

With this view you can obtain last failed job steps without using visual interface.

SQL Server Agent Schedule Decoder

This script will break job schedules down into a readable format (msdb.dbo.sysschedules)