Regarding...sp_help_job.

i would like to know, how can i process the result set which sp_help_job returns...??

select name, case when current_execution_status = 1 then 'Executing'

...

@Ashish.. thanks for the query.,

yes.. i've gone through "sp_help_job" procedure.... pretty useful..

Thank you guys...!!