activating ssis job by user

[lupidol]

Hi everyone.
I work with SQL SERVER 2005 and i have a job (SSIS job)which i'd like the user to activate whenever he wants.
My knowledge of PHP is rather poor but i thought PHP is the right intermediator between a USER and SQL Server.
The thing is i dont know how to create a link on a web page or some other menu wher a user can choose to activate a SQL 2005 job any time he wants.
Can i get help here ?
Thanks

 

[mrdenny]

Run the procedure sp_stop_job in the msdb database to start the job. The login which logs into the SQL Server will need to be a member of the SQLAgentOperatorRole in the msdb database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog