Creating SQL Server Jobs with SMO

As a developer or DBA you can appreciate the power of jobs running under SQL Agent. Now think about how nice it would be to be able to create them without the UI for automating routine - or not so routine - tasks. Tim Mitchell does a nice simple walk through of creating a job, job step, and job schedule using SMO. If you're new to SMO take a look at his profile to see a bunch of related videos!

Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

Jamshid Nouri on 6/22/2009

excellent short and effective demo!!!!

Fola on 8/21/2009

Straight to the point