Is it possible to run a SQL Server 2005 job from an asp.net intranet page? I've been opening up SQL Server 2005 and manually running this and thought it would really be convenient if I could just click a button on a 开发者_高级运维web page instead.
I asked a similar question not too long ago and got some good results. The short answer is "Schedule an agent job when you click the button". See Remus Rusanu's answer on this question:
Run long-running sproc (that doesn’t need to return) from ASP.NET page
精彩评论