"Jeff C" <JeffC@xxxxxx> wrote in message
news:89ABF7DC-C561-4C58-B437-B9EA8DD1E0C3@xxxxxx
Quote:
>I am trying to buid a script to be used by a person at their desktop
>machine
> to execute a SQL Server Agent job on the server.
>
> I need help sorting out the syntax of a VBS script I found that will do
> the
> job. Any assistance/suggestions appreciated greatly.
>
> 2 questions on the script below:
>
> 1. ("SQLDMO.SQLServer") should it be (nameofSQLServer.SQLServer)?
>
> 2. Using Windows Authentication: can oServer.Connect(".", "user",
> p@xxxxxx) be oServer.Connect("nameofSQLServer.SQLServer)??
>
> Dim oJob, oServer
>
> ' Creates the SQLDMO SQL Server object
>
> oServer = CreateObject("SQLDMO.SQLServer")
>
> oServer.Connect(".", "user", p@xxxxxx)
>
> ' Then Obtains the job to start
>
> oJob = oServer.JobServer.Jobs("MyJob")
>
> ' Start the job.
>
> Call oJob.Start()
>
>
> Thanks in advance
>
> --
> Jeff C
> Live Well .. Be Happy In All You Do
I'm not familiar with the SQLDMO provider. See this link for connection
strings:
http://www.connectionstrings.com/
When using Windows Integrated Authentication I use "Trusted_Connection=Yes"
in the connection string in place of user name and password. In your
example, the "." undoubtedly means the current computer. If your server is
called "MyServer", you would use "MyServer" to connect to the default
instance. If you have a named instance, for example "MyInstance", use
"MyServer\MyInstance".
A search on SQLDMO gave me the links below, which might prove more useful:
http://www.sqldev.net/sqldmo/SQL-DMO-FAQ.htm http://www.sqlteam.com/article/introduction-to-sql-dmo
From the last link I believe you want to use:
Set oServer = CreateObject("SQLDMO.SQLServer")
oServer.loginsecure = True
oServer.Connect("MyServer")
where "MyServer" is the name of your server (if there no named instance). I
have no idea how to start a job, but I suspect it should be:
Set oJob = oServer.JobServer.Jobs("MyJob")
where "MyJob" is the name of a job.
--
Richard Mueller
MVP Directory Services
Hilltop Lab -
http://www.rlmueller.net
--