January 6, 2014 at 4:20 pm
I would like to know what other DBA's use tool for managing all sql jobs in one place.Below are my requirements:
i) Tool should have capability to execute jobs only on certain servers, kinda like have enable/disable type of flag.
a) Good to have the capability of running the same code inside the job across multiple database in parallel ( powershell?)
ii) Should give good error logging per server.
iii) Dashboard for all the jobs.
Please let me know which tools you have been using for this. Thanks in advance.
January 6, 2014 at 4:38 pm
curious_sqldba (1/6/2014)
Please let me know which tools you have been using for this. Thanks in advance.
SQL Agent. Doesn't do everything that you're looking for but we have a centralized server for all dataload jobs and each server only does local maintenance as its personal jobs (reindexing, etc). It's what I've used... well... everywhere though.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 6, 2014 at 11:01 pm
Yeah, pretty much SQL Agent. You can set up multi-server management with it too. I wrote an article on this topic a little while back that might be a little helpful[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2014 at 3:37 am
Grant beat me to it! Follow that article and you can't go wrong. I followed his advice in a previous role and it simplified management of many servers. 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply