dbTalk Databases Forums  

Can I Created a BPA 'Job'

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Can I Created a BPA 'Job' in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
B.W.
 
Posts: n/a

Default Can I Created a BPA 'Job' - 06-09-2004 , 08:36 AM






Can I created a job that I can send to my Service Delivery group to run on the Production servers? I'm a developer and don't WANT access to PROD, but I want BPA run against PROD. I'd like to have them install BPA and them send them a 'package' to run. Is this available with BPA
Thanks


Reply With Quote
  #2  
Old   
Christian Kleinerman [MS]
 
Posts: n/a

Default Re: Can I Created a BPA 'Job' - 06-10-2004 , 04:39 AM






Maybe not exactly what you want, but there's a way you can get close.

Install BPA, which creates the repository. In it, create a best practice
group that scans things the way you want. You should register the servers
from production, or register them as (local).

Have your production team install BPA (they will have to create a repository
but it can be discarded) and then ask them to run bpa (likely the command
line version bpacmd.exe) pointing at your repository database. If they do
that, they'll have to execute the best practice group that you created.

- Christian




"B.W." <bw.lightsey (AT) tetrapak (DOT) com> wrote

Quote:
Can I created a job that I can send to my Service Delivery group to run on
the Production servers? I'm a developer and don't WANT access to PROD, but I
want BPA run against PROD. I'd like to have them install BPA and them send
them a 'package' to run. Is this available with BPA?
Quote:
Thanks,




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.