Hi,

I was wondering is there is a way to start a SQL Server 2000 Job from a

command line?? I know you can start a DTS using the dtsrun utility but

have not been able to find any information on starting actual jobs!!


If any one can point me in the right direction that would be great.


Cheers,
MH

The stored proc sp_start_job can be used to start jobs.

In order to do this from a command line you will need to use the OSQL
utility.

Have a look at both in BOL, or type OSQL /? from the cmd line

--
HTH. Ryan


"Biffster007" <mark.harvey (AT) onesource (DOT) co.nz> wrote

Nice one Ryan!!!

I never new the osql utility existed...

A very nice little tool!!!

Thank you very much!!!

Che,
MH