Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

how to automate dbcc checkdb Expand / Collapse
Author
Message
Posted Thursday, July 31, 2014 10:38 AM This worked for the OP Answer marked as solution


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:51 PM
Points: 17,948, Visits: 15,947
Skip the Maintenance plan node and go straight down to SQL Server Agent. Expand that node. Right-click on the Jobs node and select New Job from the Context menu.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1598377
Posted Thursday, July 31, 2014 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:46 AM
Points: 8, Visits: 28
Jason,

Thanks for your help - i think i got it. it's a bit nerve racking testing on production.
Post #1598461
Posted Thursday, July 31, 2014 2:16 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:51 PM
Points: 17,948, Visits: 15,947
cdm33.com (7/31/2014)
Jason,

Thanks for your help - i think i got it. it's a bit nerve racking testing on production.


Let's just up-vote that say 1 million times.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1598477
Posted Thursday, July 31, 2014 9:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:46 AM
Points: 8, Visits: 28
Janson, Grant and Ed,

After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's just a pain trying to do stuff without a lab sometimes.

Great forum by the way.

Thanks a lot,
Chris
Post #1598557
Posted Thursday, July 31, 2014 10:04 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:51 PM
Points: 17,948, Visits: 15,947
cdm33.com (7/31/2014)

Great forum by the way.

Thanks a lot,
Chris


Glad you like it. Stick around and you will learn quite a bit.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1598560
Posted Friday, August 1, 2014 1:57 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 4,608, Visits: 11,007
cdm33.com (7/30/2014)
SQLRNNR,

This code has hundreds of lines to it. I've got no clue what it does. I'm not going to put something like this on a production server not knowing what it does.

THanks anyway.


I agree with you that putting an unknown script on a production server is never a good idea.
However there are some very well known scripts around that have gained great popularity throughout the years, such as Adam Machanic's sp_WhoIsActive or Ola Hallengren's maintenance solution.
If you prefer, Ola's solution contains a script for consistency check and his script is much more "famous" and widely used than mine.

Ciao
Gianluca


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1598606
Posted Friday, August 1, 2014 1:59 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 4,608, Visits: 11,007
Oooops! I hit the wrong button...

--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1598608
Posted Friday, August 1, 2014 5:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 14,004, Visits: 28,385
cdm33.com (7/31/2014)
Janson, Grant and Ed,

After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's just a pain trying to do stuff without a lab sometimes.

Great forum by the way.

Thanks a lot,
Chris


Strong suggestion, get a test lab of some kind. A virtual machine running on VMware, HyperV, VirtualBox, anything, is good enough, so you can validate stuff before it goes to production.

And welcome to the forum.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1598645
Posted Friday, August 1, 2014 6:09 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:28 AM
Points: 4,458, Visits: 3,911
Grant Fritchey (8/1/2014)
cdm33.com (7/31/2014)
Janson, Grant and Ed,

After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's just a pain trying to do stuff without a lab sometimes.

Great forum by the way.

Thanks a lot,
Chris


Strong suggestion, get a test lab of some kind. A virtual machine running on VMware, HyperV, VirtualBox, anything, is good enough, so you can validate stuff before it goes to production.

And welcome to the forum.

Let me second Grant's suggestion. Even a decent desktop PC running SQL Server that sits under your desk is better than nothing. You don't even have to load it up with everything from production, just a good representation of your databases. The ideal scenario would be to have a copy of production sitting in test with the same hardware, SAN drives and everything else, but I don't know of anyone (including myself) who actually gets budget for that.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1598655
Posted Friday, August 1, 2014 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:46 AM
Points: 8, Visits: 28
Post #1598702
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse