Gift from SQL Server (Microsoft Corporation, Redmond)


Last year in December I participated in a unique contest by Microsoft SQL Server (FB page).

The contest page says…sqlserver_logo

Enter the New Year Cover Photo Challenge and help us ring in 2013 with a ‘Happy New Year’ themed message to the SQL Server community! Submit an image or photo of your own design that we can use as our SQL Server Facebook page cover photo in January, and if your entry is selected as one of our four winners, you will also receive a SQL Server Swag Set worth over $150!


On 29th of December 2012 I got  a mail from the Microsoft SQL Server team saying…

Hi there Manas,

Congratulations! You’ve been selected as a winner our New Year’s photo challenge!


They published the photo in their FB page and here is the link for the same SQL Server Cover Photo Challenge



On 18th February I received a parcel from USA where I found the following gift.




*** Sports Bottle, T shirt, SweatShirt, USB Flash Drive, USB Hub, Speaker

Thank you SQL Server and the team and special thanks to Katrina Munsell  Smile Smile Smile


Till next time “Keep Learning and Sharing”

“Be helpful, wh…

“Be helpful, when you see a person without a smile…
Give them one if yours ”
~Zig Ziglar

2012 in review

Thank you stats helper monkeys who have prepared a 2012 annual report for my blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 3,600 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 6 years to get that many views.

Click here to see the complete report.

Happy Diwali

Happiness, brightness, joy and all those other flavours are there to add to our live on this special day Deepavali. People in India (most of them) celebrate 5 days of Diwali, they are as follows.


Day 1: Dhanteras

Day 2: Choti Diwali

Day 3: Lakshmi Puja

Day 4: Govardhan Puja

Day 5: Bhai Duj



To know more about Diwali and the way its being celebrated in different parts of India visit

HTML5 Session with BDOTNET (Part I)


BDOTNET the user group in Bangalore have just started a series of session on HTML5. Last Saturday (1st September 2012) it was kick started with two beginners or Level 100 session by two all time great speakers Amar Nityananda and Lohith G N.


Windows to Go by Vinod

As the first 5 minutes are dedicated to “Quick Learning Session”, Vinod kumar From Microsoft  took us through the “Windows to go”. Windows To Go is an enterprise feature of Windows® 8 that enables the creation of a Windows To Go workspace that can be booted from a USB-connected external drive on PCs that meet the Windows 7 or Windows 8 certification requirements, regardless of the operating system running on the PC.


HTML5 – What you need to know by amar


Amar Nityananda started with answering couple of questions to set the platform for HTML5.

What is HTML 5?

HTML5 is a markup language for structuring and presenting content for the World Wide Web. It is the fifth revision of the HTML standard (created in 1990 and standardized as HTML4 as of 1997) and, is still under development. Its core aims have been to improve the language with support for the latest multimedia while keeping it easily readable by humans and consistently understood by computers and devices


HTML 5 = new markup + CSS 3 + JavaScript



HTML 5 and Windows 8?



Thumb rules

clip_image004understand that it’s “working draft”

clip_image004use the features that’s most widely supported

clip_image004graceful degradation – don’t alienate users


Frameworks Available

jQuery clip_image004jQuery UI clip_image004[1]modernizrclip_image004[2]knockoutJSclip_image004[3]Dotlessclip_image004[4]kendoUI


Some websites which were built in HTML5 for example “The Story of Less and Russ”


"HTML5” – More than just HTML5 by Lohith Goudagere Nagaraj


The web standard authority WHATWG says “ HTML is the new HTML5”

Map of HTML5


Specification lifecycle



Specification W3c


New elements in HTML5


The DOCTYPE or the DTD is much easier now its only

<!DOCTYPE html>

Now you don’t need a third party plugins for MULTIMEDIA


<video id="myVideo" controls>
<source src="videos/video.mp4" type="video/mp4"/>
<!–- insert sorry message here or fall back to SL/Flash -->



<audio src="audio.mp3" id="audioTag" autoplay controls>
<!-- Only shown when browser doesn’t support audio -->
<!-- You could embed Flash or Silverlight audio here --> 



Its just XML so it can be Scriptable, extensible, easily editable. An example of SVG


Using Javascript this is an easiest way to draw graphics. Most of the browsers are capbale of the 2D capabilities of the canvas.



Check this how easily you can find the location


The best thing I like about the new CSS3 is the rounded border Smile. The other cool features are CSS3 colours, Shadows, Backgrounds, media queries , selectors etc.

Borders { 
border-radius: 152px 304px 228px 152px; 
border-style: double; 
border-width: 42px; 
padding: 12px; 


WOFF Fonts and Font Face

Web Open Font Format allows you to package and deliver fonts as needed for more info


Prize for Blogging about DEVCON2012 by BDOTNET

I got a INTEL EXO PC from INTEL as my blog was selected for the competition for blogging about DEVCON2012 organised by BDOTNET. I got the prize from Jadeja Dushyantsinh  (Software Business Manager at Intel Corporation) and Vinod Kumar M (MTC – Technology Architect at Microsoft). Many thanks to INTEL, BDOTNET and Microsoft for organising and encouraging us to explore these areas of life. I must be thankful to Pinal Dave, Vic Parmar, Lohith Goudagere Nagaraj , Sudeepta Ganguly, Kamlesh Rao, Sandip Pani and Praveen Prajapati the members to make the BDOTNET forum platform friendly.




For some further links of HTML5 check this link


Lets meet in the next part of the series on Saturday 8th of September 2012. Book your tickets

Happy Teacher’s Day: Remembering all my Teachers


Those who educate children well are more to be honored than they who produce them; for these only gave them life, those the art of living well. ~ Aristotle



Dr. Sarvepalli Radhakrishnan

Born to a Brahmin family in Tiruttani in Tamil Nadu state, education from
Primary Board High School at Tirutani., Hermansburg Evangelical Lutheral Mission School in Tirupati, Voorhees’s College in Vellore , Madras Christian College , Professor of Philosophy in the University of Mysore, the Vice-Chancellor of Andhra University, Vice-Chancellor of Banaras Hindu University , Ambassador of India to the Soviet Union,  also elected to the Constituent Assembly of India, the first Vice-President of India , the second President of India, Professor of Eastern Religions and Ethics at Oxford University, fellow of the British Academy, awarded the Bharat Ratna ,  the Order of Merit ,  received the Peace Prize of the German Book Trade , the Templeton Prize , donated the entire amount of the Templeton Prize to Oxford University, the Oxford University instituted the Radhakrishnan Scholarships in his memory ( “Radhakrishna Chevening Scholarships”). Lets remember the great teacher on TEACHER’S DAY.   {Source:}

My Teachers and few moments of my life with them

MY First Teacher: My Father Late Sudam Ch. Dash was my first teacher, he taught me the basic values of life and how to respect to talent irrespective of caste and status. Till class four he was teaching us from 6 to 8 PM every day (after that we went to some tuition classes). He taught us some Sanskrit slokas which I still remember …it goes like “Paropkaraya phalanti brukhsya, paropkarya bahanti nadya, paropkaraya dudhanti gava, paropkaraya idam sariram“. Also my mother Late Sureshwari Dash taught me to face the struggle of life by “Stay cool and keep walking”. If I will not listen to her and skip my evening hours for studies then she used to say “Kahari kichi jiba nahi to bana budiba gosain”…….

During one of my friend’s wedding(Ramesh) in Bargarh last year in June, I met our UP school Head Master Sri TulasiRam Pradhan(Recipient of Rashtrapati Award). He is very old now but still came in his bi-cycle and attended the reception and blessed the couple. He was standing  in a corner with “Jyshobanti Guruma” and was discussing something. I saw them and went there and as usual I said “Angya Namaskar”. Jyshobanti Guruma asked Tulasi Angya..”Do you remember him?” , Suddenly a humbled eyes said “Because of these people I got award from President and am recognised as a good Teacher everywhere”…”Emane mor chua aan“…”eeta aamar Manas aaye”. “Kenta aachu bo babu…Bhagwan tate bhal bhabe rakhitaun..Tor Bapara na ke sarthak karbu..sabku sabubele khushi debu”.. Jyshobanti guruma said “bhall chkari kalana”.. Tulasi Aangya said “Karba nai, Hatpada School ra chua aaye, aamar aashirwad sabubele tar sange aache”. I thank them and  got a great feeling because still my teachers remember me and all my activities, and not to forget that we are just like the old school kids for them. Now a days we are getting busy in professional life and occupied with family responsibilities and may be not remembering our teachers, who had placed us in a respectful position in the society. But still they have the same love and affection for us and are blessing us everyday to reach the future goals.

I still remember the Teacher’s Day celebration. We used to prepare for debate and songs and on that day we will stand in a line to take the blessings of our teacher….Can’t we go back to those days??????

During my High School days once Our teacher Sri Susil Dash said “Tume gadha jadi phel heba …khali tumar handwriting lagi phel heba”. I was disappointed for a few days…then he called me once again and said “eehade bhi time aache ..practice kara…mor tumar upre pura biswas aache je tume bahut bhal karba”. I tried a lot for so many days and still trying also for a better handwriting(now somewhat manageable). Now a days I am not writing that much (due to computerised work culture) but still I remember him whenever i write something.That one statement that they believe us & our talent , takes us to the next level.

Those who stood first in school events(Town High School) they can participate in block level OSTA competitions. I stood 2nd in QUIZ so was not selected. One of the boy’s name appeared twice in the list (in QUIZ and in Essay), but he can only participate in one. That day while I was roaming around the school field, one of our High School Teacher Sri Khageswar Meher(popularly know as Meher Aangya) called me and told come to the Head Master’s room. I went there and our Head Master Sri Narsingh Bishi asked me “why do you stood second in QUIZ?”. I kept quite ..he scolded me for that and then they told  “don’t worry …we called you to inform that you will be representing our school in the OSTA quiz completions, go and practice hard and remember don’t come back with empty hand”. I felt very happy and participated in that block level competition and stood First in the QUIZ competition and again represented our block in Sambalpur. Here I learned that you know less about your potential and your teacher knows that you can. They have already discovered you through your potential so obey their advice and work on them. We had a small “QUIZ Society”, under the mentorship of Sri Sushil Dash and we used to practice during the last period of the day.

During  my college days I attained a NSS camp in a near by village(I was the team leader). After working very hard for some 10 days we decided to give away the best Volunteer Award. Our guide Shri Prahallad Dora (Professor, History Dept) came to me and asked “whom do you think is suitable for it”. I promptly replied “Bharat”. He was quite for some time and said “You know I have always kept a  little soft corner in my heart for you, and today I am proud of you for your decision“. After a couple of years I met him near Main Road, Bargarh and he spent around 20 minutes and asked me about my job , life , health and everything and said “I remember those NSS days and hopefully now also you must be doing the good work for the society with same spirit and motive”.

Basics are important for a person to excel in every sphere of life. Concentrate on your basics and never ask for spoon feeding” said Lalit sir …Sri Lalit Kumar Barik (My Mentor, Guru, Guide of my life’s journey in all the way). Even today also if I face any kind of difficulties either relating to professional or personal life… I used to call him and he will solve that within minutes. He is the one who changed my attitude towards life and forced me to think about the broader aspect of life also advice me to do something that he always dreamed of. Even I remember the time when I have some issues in my career or studies and if I will ask my parents ..”what to do?”. They will advise me “Speak to your Lalit sir and check if he has something for you”. Now my parents are no more but I can connect to them through the advice of Lalit sir.

During my MCA days we were guided by our teacher Manas Lenka, Dillip Mishra, Mahendra Senapati, Manas Swain and others. They helped us like a friend , guided us like a guru and left us getting curious to start a great career.

After coming to Bangalore I started attending different session and joined so many User Groups.In this journey I met Vinod Kumar M a technical and leadership Guru and started following his advice and guidelines to be a better human being and helping the tech community. Vinod knows that we can do it , he just put us on the track and will tell us “its all yours, keep moving”.

I salute all my teachers including Santanu sir (a philospher with his own way of analysing life), Mishra sir of Patharla UP School, Sri Annada Bishi, Shatni Guruma, Snehalata guruma, Sujata Guruma, Tapaswini guruma, Basanti Guruma, Hota sir, Manas Sir, Dilip Sir, Mahendra Sir, Sri Arvind Mishra . Surendra sir, Late Shri Bipin Dash, Sri Chitta Ranjan Pradhan, Ranjan Sir, Ganesh Sir, Sushree Madam and last but not the least Jiten Sir(who gave a professional touch to my career). (All these teachers are  from Hatpada UP School, Town High School, Panchayat College, MCA ,NIIT and my professional days).

NB. I might have missed some of my teacher’s name but still if I close my eyes …I can see them.


I like a teacher who gives you something to take home to think about besides homework.  ~Lily Tomlin


(I blogged this in the year 2010)

DEVCON-2012 by BDOTNET (4th August 2012)

                   Its a privilege and am honoured being a member of the BDOTNET group. We meet every fortnight and discuss about latest technology, meet the technology expert, learn from the sessions by speakers & best part is the networking with great and innovative minds while sharing information. The interest for community attracts many folks to forum like BDOTNET. The funda is simple  “Lets grow together” Smile.

After a couple of regular UG MEET this year we got this opportunity to experience a technology extravaganza DEVCON-2012. I attended the #devcon12 this Saturday at Microsoft Building, Bangalore. Some of the tips , tricks and learning I was interested to share goes like this.

Let me clarify few things…If you have missed devcon12, may be you have  missed


some funny moments with technology, some great learning,  some goodies, some books , you missed the opportunity to meet speakers , great products demo, technology enthusiast and above all some great authors.


After the keynote by Ranjan Bhattacharjee (Group Manager, India Global Technical Support Centre, Microsoft) the great technology events begins with lots of enthusiasm and passion. I remember Ranjan saying “With a little tweak you can take this technology to any device and keep working on your skill be it C# or it is HTML5, you can still develop great product with Windows 8”. He deliver a nice and a quick intro on windows 8 and welcome everybody to the devco2012.

Fortunately/unfortunately I attended some great sessions and missed some very great toSad smile.


ASP.NET MVC4 + Web API by Chaitra Nagaraj

Just before the session Chaitra asked me “How many??” , I told her “Housefull Smile” and it was a housefull session. The love for web brings everyone to session like ASP.NET MVC .

You can create new APIs using this new ASP.NET Web API framework. She displayed some really cool demo and put emphasis on how to cover a larger audience starting from web to mobile devices by designing HTTP services using ASP.NET Web API.

You can install the mvc4 RC from and start learning it from . If you need some documents on the same visit Just for HTML5 lovers check what you can do with MVC using the html5 & JQUERY datepicker

Query composition, Code-based configuration, Content negotiation and so many other cool features are there in the ASP.NET web API. Chaitra has promised she will be coming back with some other cool demos in future UG Meet.


Building Applications for Intel Ultrabook Platform and Windows* 8 by Rajagopal A

Rajagopal is a Intel Ultrabook Technology Champion and travel more than 80KM everyday to build his passion and provide a shape to it. He demonstrated the new UltraBook the slimmest ever model I have ever seen. After the first view itself I was “Inspired by Intel”.

Once you have this Ultrabook in your hand “Suddenly everything else seems old-fashioned”

Its true when Intel says “Intel® Rapid Start Technology returns your Ultrabook to full operational power within seconds, so you can jump right back into everything you were doing.”

He displayed the beauty of ultabook with Windows 8 and gave some tips and tricks to develop the touch based , gesture based, sensor based and others on the Windows 8 platform with APIs from Microsoft. The best thing is he promised a half day meeting if we can come up with some apps for ULTRABOOK and need some help/suggestion on the same.


Ignite the Leader within you by Vinod Kumar

Vinod ~ “Let me ask you couple of questions”

What is leadership to you?

Are leaders born or made?

These are very common questions , but if you can answer these in uncommon way you get it.

When you watch movies like LAAGAN , whether it really motivates you or just for the sake of entertainment you loved it. You may recall  the scene where Amir Khan convinced the management (sarpanch) and the team players to include “Kachra (was treated as untouchable)” in the cricket team telling “The team is efficient but the best part is what we don’t have or what we are missing will be fulfilled by Kachra”. Amir Khan has displayed the real Leadership attitude and managed to bring Kachra into the team.

Real leadership is being the person others will gladly and confidently follow.

Its always good to follow leaders but at the same time find out the leader inside you

“The first person you lead is YOU.”

Some keywords that focus on the “Leadership Aspect” are Self Confidence, Accountability, Focus on the whole, courage etc. Just try to cultivate this and define yourself.

Emotional Quotient controls you many time, before you flow with this – control your Emotional Quotient. People are attached to leaders and not managers. Being a manager doesn’t make you a leader.

Vinod Kumar , a all time favourite speaker of mine presented a different topic and try to ignite the mind of the young and talented professionals to start thinking different as they can. We have never missed a session from Vinod, because of his guidance. He is guru for me & Sudeepta.

He suggested to some good books: 7 habits of highly effective people, Start with Why by Simon Sinek,  Lets get real or let’s not play by Mahan Khalsa

He delivered more than what we have expected for the day. The session is not the end , he has open his teaching through his blogs on the no-technical aspect of a highly technical professional.

SQL Server Tips and Tricks for Web Developers by Pinal Dave 

People consider most of the SQL session as dry. Ask them to attend a session by Pinal Dave. I don’t want to praise him because he presented a nice session and people enjoyed a lot, but I should praise him because every single morning he teaches me a new concept in SQL Server and I love the way he does it. I want to congratulate him because in last 5 years  @pinaldave has completed 2200 blog post at @sqlauthority & 22 Episode of SQL in Sixty Seconds. I heard Vinod telling “Pinal works very hard and prepares a lot”. That hard work is his key to success and his energy and passion he gathers during each and every presentations he delivers.

This time also it was LOL SmileSmile session. This time he taught some fundamental but nice concepts for performance using keywords IN, EXISTS and JOIN. Scalar Functions help you to give a tough time to the DBAs Smile. (Do not try it in your production but )


Visual Studio 2012 – Tips & Tricks by Lohith G N

A much awaited speaker for the day with his cool “Tips & Tricks” for speeding up development with Visual Studio. Love to use the keyboard Smile

Every shortcut he spells the audience used to say “WOW”. Visual Studio 2012 is the latest offering from Microsoft in the Integrated Development Editor segment.

Check some of the shortcut provided by MSDN

Lohith is a true BDTONETTER by heart , the best part is in each of his presentation he proudly claim that. This entire devcon12 was smoothly organised because of his hard work and dedication to the details.

HTML5 – what you NEED to know by Amar Nithyananda

This session was to clear the confusion , whether to go for the much hyped HTML5 or not and how are the Microsoft tools and technology are related to HTML5.

Amar demonstrated some cool demos with Visual Studio , MVC using HTML5. He told bits & Bytes on using different websites to check compatibility of HTML5. Which browsers supports the maximum features. He spoke about different new features on HTML5 and how its gong to impact the web.

Amar will be sharing the slides of his talk in FB for all.

Closing Notes


Finally Vinod presented the vote of thanks to everyone including the audience, the speakers, the volunteers and last but not the least the companies who made this day, the sponsors TELERIK, Microsoft, Pluralsight and INTEL.

I met the author of one of my favorite book 3Lives Srinic.

Everyone who walked out from the room got a Pluralsight Subscription coupn worth $29 and keychain from Telerik. Couple of them got books from SQLAuthority, T shirts from Telerik and almost all of them with great learning from the day.

Intel also announced a contest for which Lohith says

exopc-hands-idf-2010-09-1319-15-36-rm-eng If you did not attend the DevCon 2012 event. Intel one of the sponsors of the event has announced "EXO PC" as a giveaway to the best blog article on the event. So those of you who attended the event – hurry and write what you felt about DevCon 2012 as a blog post. paste the link to the blog post on BDotNet facebook wall….. so whos gonna win the EXO PC"

Be a BDTONET member today check the image links. bdotnet imagestwitter

Like every time this time also I got couple of followers in twitter Smile

I write for BeyondRelational also. Please provide your feedback to make this blog more readable.

Till next time “Keep Smiling”

UG Meet by BDOTNET & BITPro on 7th April 2012


Reliving TechEd 2012 with Vinod Kumar 1


Being a UG member I always try my best to write my learning about each and every UG meet I attend, hence I never thought of missing this one also 🙂 . I wrote about the topic and about the speaker here. This post will provide links to so many URLs where you will find more about the topics covered as well as you can go through some of the blog written by other members about the topic and about Vinod Kumar.

As decided the UG meet was on 7th April and I was there at Microsoft Building by 10AM. To my surprise already people were there and they were discussing with Vinod Kumar and Lohith, me and Sudeepta(@skganguly) joined the conversation. I met Pinal Dave (@pinaldave), Lohith(@kashyapa), VijayRaj(@msigeek) ,Sudeepta(@skganguly), Dr.Pavanaja(@pavanaja), Balmukund(@blakhani) , AmalDev (@amaldevv)  , Kamlesh Rao(@kamleshrao ), Praveen (@stpraveen1 ), Sandeep Pani(@sandippani),  Rajesh Patel (@PatelRajeshK ) , Gopal Debta and …. at #ReLiveTechEdIn

Vinod Kumar During the session. A complete DEMO based sessions.

556125_3749185171535_1333515319_33612885_191408406_n 532834_3749219412391_1333515319_33612947_1999688312_n (1)

Pinal Dave gave a small presentation on “Who is Vinod” and we all got to know about the achievements and contribution by Vinod for the community till date. Kamlesh Rao twitted saying “A presentation about SQL Server Agent Vinod Kumar by Pinal Dave” :). Vinod is more than a Brother, Friend, Philosopher, Sensei, motivator and guru for all.

305938_3749205132034_1333515319_33612916_551685971_n Pinal_pavanaja

Lohith addressing the audience

Sharing TECHED experience

532447_3749225972555_1333515319_33612965_2146055826_n 540602_3749198731874_1333515319_33612903_1663076959_n

Kaun hai udhar??

Jokes and networking

538380_3749224772525_1333515319_33612960_1593092088_n528030_3749226772575_1333515319_33612971_839973522_n 522491_3749227172585_1333515319_33612972_424511810_n529357_3749223932504_1333515319_33612958_948387244_n



The session was very much interactive and everyone from audience participated in the discussion. There were lots of Q&A and everyone who gave correct answer got goodies from #Telerik and #Pluralsight. Also Pinal Dave distributed SQL Poster from SQLAuthority to everyone present in the room.

There were lots of goodies and excitement but without much delay Vinod started his session on the topic Sys Internals. Here are some points from the session:

  • A full demo on sysinternal tool like PAL, LogMan, VMMap, Process Explorer, Resource monitor.
  • It was all about Tools to manage, troubleshoot and diagnose your windows systems.
  • Disadvantage of PerfMon is that its difficult to decipher, PAL is an alternative.
  • Powershell is used behind the screen to run PAL.
  • Logman can convert from one format to another.
  • Each process has 4GB and 2GB of that is taken by kernel.
  • WOW is Windows on Windows.
  • If you see an yellow color in Proc Explorer means its running a .net code.
  • Virtual memory is low because the system commit limit (RAM+ page files) has been reached.
  • Virtual allocation will happen before physical memory allocation
  • GPU Usage
  • To know about the processor family on your pc/laptop Goto Run. Type msinfo32 to know about your processor family.

image GpuusageKamlesh


SQL server 2012 changes on Storage, Security, Checkpoint & memory.


Ask Vinod on SQLServer, Intel Architecture and Memory Internals I bet you will be satisfied with the answers. Some point from the session were

  • How to change the target recovery time of a SQL Server database in SQL Server 2012 and the default target recovery time is 0
  • A checkpoint creates a known good point from which the SQL Server Database Engine can start applying changes contained in the log during recovery after an unexpected shutdown or crash(as told in MSDN).
  • Internal checkpoint is different from Indirect Checkpoint


  1. what is the different between Virtual Size, Private Bytes and Working Set on Process Explorer tool
  2. what is virtual address & physical address?
  3. what is cluster and sector?
  4. What is transaction log used for? Is that get corrupted?
  5. Can you have more than 8K pages in the buffer pool?
  6. Is the max. memory setting on your SQL Server accurate?
  7. What’s a 3GB switch ?
    Photographs , Vinod’s Blog, Sudeepta’s Blog, Praveen’s Blog, Nakul’s Blog, BDOTNET, BITPRO

    There was a 128bit joke came out from the session. If you have missed it …you have missed it. Don’t miss next time because….


    UG Meet teen cheeso se chalta hai  Share, Learn and Network  ya phir Knowledge, Goodies aur demo.

    Be helpful.When you see a person without a smile ,Give him yours.

    ~zig zigler

    #JustLearned : Checking the Job Schedule status of a SQL job

    We check daily and weekly jobs schedule status that has been scheduled in SQL server in many servers for different projects. I wrote some queries to get the status as below.(if you have better solution please comment)

    We can use a readymade solution SPHELP_JOBSCHEDULE store procedure which takes jobid, jobname, schedulename, scheduleid and schedule descirption. But this will return multiple columns and what if we have to query only the enabled status of a schedule.

    So the other approach may be to query the MSDB table DBO.SYSSCHEDULES which will give us the ‘enabled’ column from which we can get the Schedule status of the job. For more information we can join the dbo.sysjobschedules and dbo.SYSJOBS.

    SELECT enabled as JobScheuduledStatus FROM DBO.SYSSCHEDULES WHERE [NAME]=’JSCH_HR600d’

    *this one is already published in