The Multifunctioning DBA

Apr 18 2012   8:00AM GMT

Jobs Repository



Posted by: Colin Smith
Tags:
Powershell
SQL Server

I have been working on a task that will populate a database with a ton of information about jobs from all my sql servers and allow me to do reporting on it. Of course I chose powershell to write the script to go get all my data and to populate my tables. I am also using some SPROCS in order to validate my data and get the correct data into the actual tables. I am doing that so that Powershell can just dump the raw data into staging tables and then the SPROCS determine what needs to be inserted, updated, or marked as deleted. Notice I say marked as deleted and not deleted. That is so that I will have some history about when the job was deleted from the SQL Server. I will be posting this here as I go along. My database structure is built so that not just sql server job data can be stored but oracle as well. I am not writing the sripts to gather the job info from the oracle instances since those may be in Oracle and may be in Cron. So over the next few weeks you will start seeing DDL, SPROCS, and Powershell code to get this going. Then perhaps some reports as well.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: