scmadden
5 years agoNew Contributor
Run a SQL Job from JScript
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?
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