I need to simply run a SQL Server Agent job. I don't need to return values; it is more of a middle man job. Could I do something like this:var SJob;
var Sjob.ConnectionString = "all the stuff that goes in here...";
SJob.ProcedureName = "SendJobs";
Or would I be going about this incorrectly?
Go to Solution.
I've found the following example demonstrating how you can call an SQL stored procedure (even with parameters):
View solution in original post
What happened when you tried that?
Well, I haven't yet. Can't extend my trial either. Should get a license next week. It should work for an actual stored procedure, but this is for a job...
Have you managed to have this script worked?