How can I schedule a job in Sql Agent (Sql Server 2005) via C# code?

Question

Hi I'd like to schedule an existing job in the Sql Server 2005 agent via C# code... i.e. when someone clicks a button on an asp.net web page.

How can I do this?

Thanks!

Answer 1

Have a look here: SMO Job Class

The SQL Server Management Objects (SMO) Class Library lets you do practically anything programmatically in SQL Server.

Answer 2

Check out:

http://msdn.microsoft.com/en-us/library/ms186273(SQL.90).aspx

Covers both SMO and T-SQL methods.