February 8, 2011 at 10:47 am
About a year ago, my whole life changed as my company went through a DOD audit.
I now run my SQL backups using a convoluted Windows Scheduler...as they took the SQL agent away.
And I have to RDP to my servers just to login to SMS, since SMO/DMO had to be disabled.
However, I have a new boss now, and he is encouraging me to fight back.
Have any of you had to justify the needs for the SQL Agent or SMO/DMO before? If so, can you provide some solid examples?
Thanks.
February 8, 2011 at 11:01 am
SQL Agent and SSMS are highly overrated... but it ranks right up there with Oxygen.
The sad truth is that you need to prove you're wasting time and gaining nothing by doing it this way. Moreover that you'd gain a lot by using sql agent and your "local" ssms.
However I have not much else to offer to you. I always have to rdc in and it's not a big issue for me.
Windows scheduler would probably piss me off tho.
February 8, 2011 at 2:03 pm
Every job can be done in a primitive way.
Just not as fast, smooth, reliable, agile, ...
Why I like sqlagent ?
- managebility
- security
- job history (no need to log to textfiles on obscure folders to be scanned by monitoring tools for error codes)
- proxy accounts
- schedules
- the available subsystems (and their security )
- monitoring using alerts
- ad-hoc job requests by low auth. users within db context
- single interface management (ssms)
- We try to only perform strict db stuff (maintenance, backups, sys checks, dbcc checkdb, archiving, monitoring, ...) at the local sql instance.
I hope MS will finally enhance sqlagent roles, ownership levels with the next sqlserver version.
I only use SMO for scripting purposes.
That could be avoidable if all actions are 100% version controlled and your sysadmin/dba have comparison tools.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply