Last week there was a question in MSDN Forums “How to get alerted when a database status change”. This piece of code can be used in a job to notify DBA’s about the status change of a database. The job can be scheduled say once every minute which checks the status of a database and … Continue reading
Query to get status of all jobs in Autosys
The below query will help to find the status of jobs in Autosys. You need to run the query against the SQL Server database backend of Autosys. In the query I have declared a variable @GMTOffset. To get the GMTOffset value you can get the Offset value from the table “ujo_alAmOde”. Declare @GMTOffset int; select … Continue reading
Get status of jobs in Autosys using job command
Autosys is a tool which helps automating jobs across platforms. I had this need to find the status of a Job but all I knew was that the command used in the Job. When you have 2-3 jobs its quite easy to find the job and the status but when you have 100+ jobs its … Continue reading
Define Query Parameters dialogue box while creating a report using Report Wizard
I came across this scenario multiple times while creating a Report using the Report Wizard in Sql Server Business Intelligence Development Studio. While creating report using the wizard, first we set the Data Source. Our next step is to write/paste the query that we need for the report, On clicking next this pop up occurs. … Continue reading
April #Meme15 : Blogs that stand out
This is my first entry towards #Meme15 and this month’s #Meme15 by Jason Strate (Blog|Twitter) is about 10 blogs that has outstanding information about SQL Server. Well there is enormous amount of information available through different blogs and many of the blogs are followed globally, I am listing few which are Gems and contain information that … Continue reading