Stored Procedure that creates and runs a job, called from .NET
Posted on 2006-06-21
I am trying to run a stored Procedure from a .NET page, which creates a job, that runs a DTS package. It works fine when I run it from the server, but when I run the Stored Procedure from .net I get the following exception:
System.Data.SqlClient.SqlException: The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
Some permission issue I guess. Can anyone help me get this running, I am so close!