Click here to Skip to main content
Click here to Skip to main content

Create New Jobs In SQL 2012

, 14 Jul 2013
Rate this:
Please Sign up or sign in to vote.
How to create new jobs in SQL 2012

Introduction

This post lists how to create new jobs in SQL 2012.

  1. Open ssms login in SQL Authentication:

  2. Start the SQL server agent if it is red color turn on like this:

  3. After starting the SQL Server agent double-click this agent, create a new job like this:

  4. Give name to this job I created name as sampledb_backup:

  5. Then, you can choose which logins you decided to authorize and category, also choose what we needed:

  6. Go to the second tab STEPS for what we performed in the database:

  7. Click new and give new name, then what type of language is to be selected. I am selecting T-SQL:

  8. After selecting this, you have to insert your queries like this or by using open button, you have to browse your queries:

  9. Then, pick the advanced button whether you have arranged one more step or finished my job you have used by this window:

  10. If job is a failure, what's next? You can run another job or quiet the job:

  11. Also, you can save that success or failure in a T-SQL format set path for output:

  12. After completing all these steps which login to perform this job, so you choose logins:

  13. Click ok, then click on the SCHEDULING tab:

  14. Give the name that you already created, time, occurs, time, date for user options:

  15. Other three tabs like alerts, notifications, targets is your choice of action can be performed like sending mail, etc. That’s all. If there are any modifications to be done after saving that job, go to SQL Server agent->jobs->sampledb_backup->double click, then modify it:

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

apachearun
Database Developer IAP Pvt Ltd
India India
Production & Application DBA ,Asst Programmer

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 14 Jul 2013
Article Copyright 2013 by apachearun
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid