SQL Server DBA Tutorial 117-How to Create Job using SQL Server Agent

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:
sqlage.blogspot.com/2015/03/how-to-create-job-u…


Visit our website to check out SQL Server DBA Tutorial Step by Step
techbrothersit.com/2014/12/sql-server-dba-tutor…