Executing a SQL job from within VB
-
Can anyone tell me ifn there is a way to execute a SQL server job from within VB 6?
-
Execute the following stored procedure just as you would any other.
EXECUTE msdb..sp_start_job @job_name = 'your job'
You must be a sysadmin to start a job that you do not own.
Norman
-
thanks for the tip friend.
-
Keep in mind you can only start jobs you own !
To avoid overauthorising users so they can start jobs, I use an alert which starts the job, so they only raise the appropriate error in the appropriate database.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply