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
Printable View
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
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.
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.