×

SQL Agent

Azure Automation: Your SQL Agent in the Cloud

January 12, 2018

This is a session about Azure Automation service and how you can perform some of SQL Agent functionality against Azure SQL Database using runbook. I presented the session to following user groups and events. PASS DBA Virtual Chapter (Asia Pacific Region) on November 15, 2017 PASS DBA Virtual Chapter on February 28, 2018 Boston Azure DataFest […]

Warning: Non-existent Step Referenced While Creating SQL Agent Job

April 6, 2017

Today there was a question submitted in dba.stackexchange.com with the heading “Suppressing non-ANSI warnings in SQLCMD script”. Details here. In summary, this happens when you use a script to create a SQL Agent job and one of the job steps has conditions (under advanced properties) to go to certain steps in case of success or […]

Schedule SQL Agent Job With Availability Group

January 28, 2016

There was a tweet that came last night from Lohit about “need guidance on how to enable a set of jobs on secondary AG as soon as failover happens from primary to secondary AG”.  I have implemented a solution for most (I am using “most”  literally because I have not done this for all jobs) of […]

SQL Agent Jobs With Notification Enabled

January 8, 2016

DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]

Manage SQL Agent Job History

October 2, 2015

Recently in one of our server row count in MSDB.DBO.SysJobHistory table exceeded 100 Million and looking at job history was slow via SSMS. It was impossible via the GUI. Because we had about 50 jobs that were running frequently (called from a listener mostly once in every 2 to 3 minutes). I was curious if […]

My Stackexchange Profile

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Announcing the 1st Data Platform Discovery Day - a 100-level, 1-day virtual conference intended for those looking to ... change their career path or data platform beginners looking to expand their skill sets. CfS live at https://dataplatformdiscoveryday.com/ til 4/13. US day 4/29, Europe day 4/30.

We are pleased to announce #SQLSaturday #1000, in Portland, Oregon on October 24, 2020!

... http://www.sqlsaturday.com/1000/EventHome.aspx

Since #SQLSat started in 2007, there have been some amazing milestones achieved along the way. Check out some of the highlights by clicking the image below! #sqlpass

I know many of us are biased between blue and red.
U want to know the fact. Call someone you trust and works in NY city ... hospital.
I did with 2 doc, 1 admin and 1 finance person.
You are bound to get angry and not trust a bit of these TV shows at 5pm.

#CoronaPandemic

No days off. Thanks to some serious teamwork, Massachusetts is set to receive over 1 million N95 masks for our ... front-line workers. Huge thanks to the Krafts and several dedicated partners for making this happen.

Load More...