
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