SQL Server Jobs

[judysomething]

Could somebody tell me if it is possible to call the jobs(which is in the SQL Sever Agent) in VB 6.0?
If so, How?

Many thanks

[JHausmann]

I believe there's an extended stored procedure that'll let you get to it. You can also get to it by adding a reference to Microsoft SQLDMO in your program. You'll need SA authority _and_ you'll want to play with the Jobs collection.

[judysomething]

Yes JHausmann, I got it.
There is a system stored procedure in msdb which is called sp_start_job that can start the job in SQL Server Agent.

Thanks a lot.