|
|
|
|
|
|
|
|
|
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!
|
|
|
|
Duration:
|
3
mins
39
secs
|
|
Skill Level:
|
200
|
|
Rating:
|
4.39
out of 5
|
|
Publish Date:
|
September 09, 2008
|
|
|
|
About the Author
|
|
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.
|
|
References
|
|
Comments
|
Jamshid Nouri on
6/22/2009
excellent short and effective demo!!!!
|
|
|
Straight to the point
|
|
Craig Matthews on
11/28/2011
Please speak a little louder. Even with my volume all the way up I could barely hear you.
Thanks
|
|
|
nice !! and great
|
|
|
How do you create such a project? The interface looks like BIDS, but there's no mention of project type or required libraries.
|
Must Be Logged In
|
|
|
|
|