Check Jobs Current State

Total article views: 897 | Views in the last 30 days: 9

 Rate this |   Join the discussion |  Briefcase

I created this script in an attempt to better automate many different jobs that run each morning, as part of a datawarehouse build. I use it to not only tell me what jobs are currently running (so that I can manage how many I would like to run at a time), but what happened to the job after it completed (or not). The parameters are: @jobs = Comma seperated list of jobs to check @is_running = Should the procedure wait until the job indicates that it is "running" or not. @max_seconds = How long should the procedure wait for the job to indicate whether it is "running" or not. @pause_seconds = Controls the interval of time between job status checks. @retrying_equals_running = Should a "retrying" state be considered as "running" The procedure returns the job status as an integer that indicates the following: 1 - successfull 2 - retrying 3 - cancelled -1 - not started -2 - executing 0 - failed If anyone is interested, I can post the scheduling procedure as well... I'll wait to see the ratings that this script gets. Gabe Green

Total article views: 897 | Views in the last 30 days: 9