 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
30-05-06, 04:41 PM
|
#1 |
|
Guest
Posts: n/a
|
SQL server
hi
i'm trying to get the script that is run by an sql server maintenance plan.. how do i do it, i've tried using SQL profiler / tracing the commands but there must be a better way? the "msdb" database holds the maintenance plan ID but not much else... |
|
|
30-05-06, 09:39 PM
|
#2 |
|
Guest
Posts: n/a
|
my memory is a bit sketchy on this one and I dont have a copy of SQL on my home PC, but I'm pretty sure that if you run the wizard to create the maintenance plan it has an option to export the plan as a script.
or... check out the job steps that the maintenance plan creates. each job step probably comprises TSQL code that you can copy/paste HTH Terence |
|
|
|
31-05-06, 05:40 AM
|
#3 |
|
Guest
Posts: n/a
|
Maintenance plans are in the Management section in Enterprise manager. Within them is a task tab (i think its called) with the steps/scripts it executes
If script looks something like "exec script" its running a stored procedure which is located withing the DB its running against. |
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| secure file server | DoubleD | Idle Banter | 5 | 27-09-06 12:46 PM |
| SQL server and VB | mysteryjimbo | Idle Banter | 10 | 18-03-06 09:02 AM |
