How To Create Job Using SQL Server Agent

382 Views

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Published Sep 5, 2015

In this video you will learn how to create a job using SQL Server Agent in SQL Server. It shows step by step process of creating the job using SQL Server Management Studio as well as T-SQL Script in SQL Server. It teaches you how to configure Job parameters such as names, job owner, categories and best practices of choosing Job owner while creating SQL Server Agent Jobs. It helps you to configure Job step parameters and will walk through different step options and how to use them under what circumstances. Also you will learn how to configure Job history options such as storing Job output to a file, loading into a table and including job execution history in Windows Application Log. It talks about best practices of storing Job history as well as Job retentions in SQL Server Agent.

Blog post link for the video:
http://sqlage.blogspot.com/2015/03/how-to-create-job-using-sql-server.html

Category: Tech

Be the first to comment

Sign in

Create your account

Add Video

How To Create Job Using SQL Server Agent - SQL Server DBA Tutorial

Up Next