scmadden
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
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?Solved1.4KViews0likes4CommentsQuerying a SQL Server DB and returning more than one column
Instead of recording a script, I am attempting to query a given database table myself. I am able, but I am only able to return records for one column. Is there a way I can append to what I have here in the while loop to add columns and view like a table in my log? My sample code: function RunSimpleQuery() { var AConnection, RecSet; //Create ADO connection AConnection = ADO.CreateConnection(); AConnection.ConnectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=*******;Initial Catalog=*******;Data Source=*******"; AConnection.Open(); RecSet = AConnection.Execute("SELECT * FROM someDB.SomeTable WHERE statuscode != 4"); Log.AppendFolder("This is a test"); RecSet.MoveFirst(); while(! RecSet.EOF ) { Log.Message(RecSet.Fields.Item("statuscode").Value); RecSet.MoveNext(); } AConnection.Close(); } Like I said, I have more than one column to return in results for log. Any help would be appreciated. Stephen MaddenSolved1.8KViews0likes3Comments