Run a SQL Job from JScript

[scmadden]

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? 

[Marsha_R]

What happened when you tried that?

[scmadden]

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...

[TanyaYatskovska]

Hi @scmadden,

Have you managed to have this script worked?

[TanyaYatskovska · Accepted 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