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";
SJob.ExecProc();
Or would I be going about this incorrectly?
Solved! Go to Solution.
Hi @scmadden,
I've found the following example demonstrating how you can call an SQL stored procedure (even with parameters):
https://smartbear-cc.force.com/portal/KbArticleViewer?name=Call-an-SQL-Stored-Procedure
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...
Hi @scmadden,
Have you managed to have this script worked?
Hi @scmadden,
I've found the following example demonstrating how you can call an SQL stored procedure (even with parameters):
https://smartbear-cc.force.com/portal/KbArticleViewer?name=Call-an-SQL-Stored-Procedure
Subject | Author | Latest Post |
---|---|---|