I have a job stored on my server and I'm trying to make a vbscript that I can run when I need to which will start and run the job. Has anyone done this? Here is the script that I have and it's currently not working. Any help would be appreciated.
Code:Dim objDMO Set objDMO = new SQLDMO.SQLServer 'Connects to DB objDMO.loginsecure = true objDMO.Connect("name of server - removed for this") ' Then Obtains the job to start oJob = objDMO.JobServer.Jobs("name of job - removed for this") ' Start the job. Call oJob.Start() 'Disconnect obj.DMO.DisConnect Set objDMO = nothing


Reply With Quote
