The Multifunctioning DBA

May 27 2011   11:59PM GMT

Powershell Start and Stop -job

Colin Smith Colin Smith Profile: Colin Smith

Today I finished writing a couple scripts that are going to be gathering perfmon counters and pushing them into a DB for me. This is great but I am going to need to run two separate scripts that do this at the same time. So I found Start-job and End-job. these are great because now I can just write my scripts to run in an infinite loop and I will control the stop time by running a stop-job when I am ready for it to end.

I did find something that I was not expecting though. In my scripts I use invoke-sqlcmd and I have the snapin loading in my profile so I did not think I would have an issue. However, after I started one of my scripts and let it run for a while, I checked my database and no data had been inserted. this is strange since when I execute the script without start-job the data flows in as expected. I did a receive-job -id 9, 9 was the id of the running job, and it showed me the output of the script and I saw errors about invoke-sqlcmd not being a cmdlet. WHAT… So I modified my scripts with a add_snapin function and I add the snapin in that function that I call at the beggining of the scripts. Now they are working great.

Love that I can run both jobs in the background and check the status of them as I need to and stop them when I am ready to.

 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: