Start a SQL SERVER Agent Job From VB

[AppSpecialist]

How do I start a SQL Server Agent job from Visual Basic?

This should be fairly simple... I think?

Thanks

 

[RickCole]

You could issue the command to execute the msdb stored procdure sp_start_job.

Rick.

 

[AppSpecialist]

Yes I had found that procedure earlier... But as an addition, how can I pass a parameter to the job that I am starting?

 

[RickCole]

You could write your parameter to a table and let your job pick it up from there.

Rick.

 

[tlbroadbent]

Check this link...

http://www.sqldts.com/article.asp?nav=1,6,208,7

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.