Showing posts with label vbscript. Show all posts
Showing posts with label vbscript. Show all posts

Monday, March 12, 2012

scheduled job control

i'd like to use external vbscript task to check [running] status of
scheduled jobs on sql database, to see is particular job running,
and may it be forced to start or stop.
do i need some special component or is all allready bilt in into sql server?
thanks for comments.Look at sp_help_job in Books Online. It should give you everything you
need.
"sali" <gabor.salai@.tel.net.ba> wrote in message
news:#g43N6AKFHA.1052@.TK2MSFTNGP10.phx.gbl...
> i'd like to use external vbscript task to check [running] status of
> scheduled jobs on sql database, to see is particular job running,
> and may it be forced to start or stop.
> do i need some special component or is all allready bilt in into sql
server?
> thanks for comments.
>
>