G
Guest
Guest
I would like to be able to send a command to a SQL Server through an excel routine. I would like to execute a stored procedure or start a job.
SQL Statement example:
1)USE msdb
EXEC sp_start_job @job_name = 'NightlyBackup'
Does anyone have sample code for establishing a connection and sending the command? How do I specify the database to use in the code?
tstumpf@ibsys.com
SQL Statement example:
1)USE msdb
EXEC sp_start_job @job_name = 'NightlyBackup'
Does anyone have sample code for establishing a connection and sending the command? How do I specify the database to use in the code?
tstumpf@ibsys.com