Execute a SQL Job from C#

[Dave]

How can I execute a SQL Server 2005 Job from C# in an ASP Page?

 

[Alberto Poblacion]

How can I execute a SQL Server 2005 Job from C# in an ASP Page?

If you are using C#, I assume that you mean an ASP.NET Page, rather than
a legacy ASP Page, even though the procedure to execute a Job is similar in
both cases.
Open a SqlConnection to the server. Create a SqlCommand and configure it
to execute the stored procedure sp_start_job with the relevant parameters to
specify your job (described in the Sql Server Books On Line). Use
ExecuteNonQuery to execute your SqlCommand, and Close the connection.

 

[Alexey Smirnov]

How can I execute a SQL Server 2005 Job from C# in an ASP Page?

Hi Dave, look at the following tutorial
http://www.sqlteam.com/article/how-to-asynchronously-execute-a-dts-package-from-asp-or-aspnet

Hope this helps