Your Information Technology Answers are Here on SSWUG.ORG

SSWUG.ORG is the one of the largest community-driven sites that focuses on enterprise technology, as more than 570,000 members regularly visit our site for answers to their questions on data management, collaboration software, development tools and cloud computing.

Our staff works to issue relevant and in-depth articles, podcasts, webcasts, expos and classes to members and non-members alike.


ARTICLES

Article

Find count of successful jobs with in range SP


The following procedure called usp_GetCountJobSuccessInRange gets a job name , number of days and run status that corresponds
to the Run status values 0,1,2,3,4,5 (SEE table)
The procedure checks the count of jobs that fall in the run status category (failed-0, success-1 etc) and that where executed within the days range (until the current day from current days - number days given)


Read this article..