Creating a job in SQL Server 2005

Question

Hi,

Am pretty new to SQL Server 2005. Can someone help me to create a job in SQL Server? This link(http://www.databasedesign-resource.com/sql-server-jobs.html) says to create under the jobs category in managememt tab. But i am not able to find one such category in my SQL Server Management Studio. Is it not possible to create a job using stored procedures or queries?

Thanks, Geetha

Answer 1

In 2005 it's sql server agent -> jobs

For tsql read this

Answer 2

Here is the MSDN link which covers Job creation, deletion, assignment etc.