Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Bernabe Diaz,
Some times you need acces to jobs' schedule related information in a server, but you do not have acess to the server agent information or there are too many jobs to check them one by one.We need a helper function "IntegerToBinary" (it is clear what is it for) to extract hiden information in columns like freq_interval from table (view) in the msdb database. IntegerToBinary is an adaption to T-SQL of the classic algorithm for geting the binary representation of an integer.That function script is in the first section after that is the report's script which display jobs' info.
Information about reports ran
this script returns some good information about databases on an instance of SQL SERVER.
information of deleted job