check MS SQL database status, and execute preconfigured jobs

[udhay prakash pethakamsetty]

Hi 


I am using pyodbc to connect to MS SQL server. I got a result for 
cursor.execute('SELECT * FROM sys.databases') statement. 

But, I dont know what fields among them must be considered to ensure that database is up and running and is fine. 

IN this https://www.mssqltips.com/sqlservertip/1477/methods-to-determine-the-status-of-a-sql-server-database/, example 1 lists all the fields. 


Post that, I want execute some procedures, I can do them with cursor.execute() in the same way. 
BUT, as I am new to MS SQL db, can someone let me know which fields must be taken into consideration to ensure that db is up and running fine.