Sql server job creation [Resolved]

Posted by Nahesh under Sql Server on 11/27/2013 | Points: 10 | Views : 1233 | Status : [Member] | Replies : 3
How to add multiple steps in the SQL server Agent Job using sql server 2008?




Responses

Posted by: Bandi on: 11/28/2013 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Go to Object Explorer ( press F8) --> Right-click on SQL Server Agent --> Click on Start to start the agent service
--> Select New Job under Jobs
Follow the wizard to create a job
--> Select New Button under Steps Page
--> Add name, description and type of job either T-SQL or SSIS package and so on
--> then you will get area to write T-SQL code for T-SQL step type
--> Go to Advanced page to set the configurations on success/failure cases.

In the same way you can add more than one steps to single job
the following link is for adding steps to a job using T-SQL
http://technet.microsoft.com/en-us/library/aa259594(v=sql.80).aspx
http://blogs.msdn.com/b/sqlagent/archive/2010/10/13/creating-multi-step-sql-agent-job.aspx
http://sqlmag.com/database-administration/sql-views-steps-setting-sql-agent

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vishalneeraj-24503 on: 11/27/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi please refer below links:-
http://technet.microsoft.com/en-us/library/ms188727.aspx
http://technet.microsoft.com/en-us/library/aa213824%28v=sql.80%29.aspx
http://technet.microsoft.com/en-us/library/ms141701.aspx

Hope this helps you.

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vishalneeraj-24503 on: 11/27/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi please also refer:-
http://sqlmag.com/database-administration/sql-views-steps-setting-sql-agent
http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2
http://blogs.msdn.com/b/sqlagent/archive/2010/10/13/creating-multi-step-sql-agent-job.aspx

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response