Project Description
Most of the time you will have a requirement for enabling users to execute a scheduled job in SQL Agent manually. You could not expect business key users to login to production and execute jobs out-of-schedule.

So i builded a small ASP.NET web site to allow users execute the job

Instead of using standart queries i used SQL server SMO (Scripting Database Objects) which is going to be a replacement for old-famous-DMO (Database Management Objects)
This project is developed under SQL Server 2008 R2 and Visual Studio 2010 environment. I can not guarantee that it has backward compability. You need to add three dll's to source code to work on it.
Here is the list of SMO DLL's:
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SmoEnum.dll
Microsoft.SqlServer.SqlEnum.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll // on SQL Server/VS 2008 only

Basic Functionalities:
Job Execute page to select multiple jobs to execute.
Job History Page to see the execution results.

As I've said, this is very primitive version which could be better by contributions. (Contributors: Welcome)
(If you want to learn SMO have a look at: http://www.mssqltips.com/tip.asp?tip=1826

Last edited Jul 29, 2010 at 12:45 AM by Offshoot, version 5