Create a new job in SQL Server 2005 with the use of code

Question

How can you create a new job in SQL Server 2005 with the use of code? And not in SQL Server Management Studio.

Answer 1

There's a series of system stored procedures that you should use as detailed on MSDN:

sp_add_job
sp_add_jobstep

Plus a couple more for settings up schedules.

Answer 2

To see how it's done by example, you can make a job in Management Studio, then right-click / script the job out to a query window.