| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-03-02 : 00:02:12
|
| Can someone let me know any 10 things that are usally automated using the SQL Server Agent, I mean besides backup what all can i automateThanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 00:16:49
|
basically anything that you can think of automating... --------------------keeping it simple... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-02 : 00:25:56
|
| anything that you want to execute it periodicallyOr even one time job that execute in future----------------------------------'KH' |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-03-02 : 00:46:17
|
| LOL good answer jen , but then ....lets says1) Backup the DB2) Import/Export of Data3) Deleting old (historical data)4) Executing dbcc commandsNow I need someone to complete the list....5) .......................Let ,me put it this way , WHAT ALL TASKS HAVE BEEN AUTOMATED AT YOUR SITE....... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-02 : 00:53:34
|
| Yes. I have 1, 2, 3 on the scheduled list. I also have several others that is application specific that perform some housekeeping and updating, transferring of data.Just curious ? Why do you want the list ?----------------------------------'KH' |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 01:10:57
|
| ah... i get it...you're asking for some routine jobs done noh? aside from those you mentioned:1. I check if the server is still running by sending out a daily email to myself2. starting the replication agents when they are down due to network failure (hiccups only)3. recompiling the sprocs periodically4. dbreindex periodically5. log shipping (note not logshipping he he he)6. send email notifications for previous day's activities (depends on what you want to know)7. audit traces... i send out an email if triggered by someone being naughtyso basically the server will be running itself --------------------keeping it simple... |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-03-02 : 01:17:55
|
| hmm have actually started a career as a DBA :p LOL , so am trying to figure it out what others do , that would be helpful to me toooooo :p Hey jen i doubt you ever work :p, cause I see you have tried automating every damn thing on earth ...... So must be good at GOLF with all the free time to practise. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-02 : 01:27:31
|
| Maybe you should consult SQLTeam's own master of automate testing. ----------------------------------'KH' |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 01:28:28
|
out of necessity Kid... out of necessityyou'll be surprised at the amount of work and solutioning I did,but hey that's that, you'll learn fast enough especially when servers start going down for "unknown" reasonsgood luck! anything can be done (that's what i tell myself  )... as for golf, nah... i like climbing rocks and sweating it out in the sun--------------------keeping it simple... |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-03-02 : 03:34:12
|
| hey jen , can u let me know how to check if the server is still running by sending out a daily email to some account ???? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-02 : 05:42:23
|
| "3) Deleting old (historical data)"We BCP the stale stuff out to files, and ZIP them up, and then delete them. makes it pretty easy to reimport the data into a temporary database if the need arises."1. I check if the server is still running by sending out a daily email to myself"I'm always curious with this approach. I would never think "I didn't get a message from ServerA this morning", so it would never work for me ... I need to have something that checks that all servers have "phoned home" and then tells me if they didn't - in a failsafe manner."4. dbreindex periodically"We DEFRAG most stuff (rather than REINDEX). We Reindex only for very small tables (our DBs are 24/7 so we don't want to shut people out whilst we Reindex)"can u let me know how to check if the server is still running by sending out a daily email to some account"We use Servers Alive for most of this work. It sounds a "siren" in the office if anything goes down, and escalates to EMail or SMS out of hours etc. It can check web pages contain specific text, IP addresses are pingable, Database can be logged into, etc. etc. It also produces a "Status" web page - which you can obviously access from elsewhere. Free for up to 10 separate "checks" I think. http://www.woodstone.nu/salive/index.aspKristen |
|
|
|
|
Tasks to automate