Click here to Skip to main content
12,827,807 members (46,939 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


1 download
6 bookmarked
Posted 14 Jul 2013

Create New Jobs In SQL 2012

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


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:


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


About the Author

India India
Production & Application DBA ,Asst Programmer

You may also be interested in...

Comments and Discussions

QuestionChange Query Pin
Member 1093133621-Jun-16 2:17
memberMember 1093133621-Jun-16 2:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170326.1 | Last Updated 14 Jul 2013
Article Copyright 2013 by apachearun
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid