Using asp.net to run a "SQL server job" thru a aspx page RSS

• • Reply
  

  pak99

  Member

  30 Points

  6 Posts

  Using asp.net to run a "SQL server job" thru a aspx page

  Mar 21, 2004 08:20 PM|LINK

  Please help. I have a job created in SQL server 2000 and I want to allow users to run the job any time they want through ASP.Net page. I tried to "SET" the oJob to point to the job but failed (see '*** below) and I may be missing some codes. I appreciated any input. Thanks Pak+++ <script runat="Server"> Sub btn_Click(S As Object, e As EventArgs) Dim oSQLServer As New SQLDMO.SQLServer2 Dim oJob As new SQLDMO.Job With oSQLServer .Connect ("ORGDEV", "sa", "998811") End With ' **** Set oJob = oSQLServer.JobServer.Jobs("Daily Email to DBA") With oJob .start End With End Sub </script> <form runat="Server" ID="Main">

  
  

  </form>