Schedule a PS Script using SQLServer Agent

Question

Schedule a PS Script using SQLServer Agent

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 730682 More actions · Answer 1

All I can add it "Allen is the man!"

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Jack Corbett SSC Guru Points: 184393 More actions · Answer 2

Now to get back to my problem.

Okay, I think I may have identified my problem. I am attempting to archive Default Trace files and I was using this command:

Get-ChildItem -Path $tracepath -Filter '*.trc' #-Exclude $currentfile

And the Exclude is for some reason making it so it does not return any files. Currently there are the expected 5. Can I use the -Filter and -Exclude parameters together or are they mutually exclusive? $currentfile is a string like log_10.trc.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jack Corbett SSC Guru Points: 184393 More actions · Answer 3

I got something working, but the question about -Filter and -Exclude still remains.

Thanks guys. Even Grant who hijacked the thread. Which is fine. Might as well use the expert while he's here.

Thanks Allen, Steve and Greg.

I removed the -Exclude and just did a test on $file.Name -ne $currentfile before I did the move.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gary Varga SSC Guru Points: 82166 More actions · Answer 4

Steve Jones - Editor (9/4/2009)
All I can add it "Allen is the man!"

Some people will do anything to climb the rankings...oops I guess this chap doesn't need to!!!

(Sorry had a really bad day and couldn't help myself - well at least I made one person smile, if only for a moment)

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Steve Jones - SSC Editor SSC Guru Points: 730682 More actions · Answer 5

:-), had to thank Allen publicly for responding to my query.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com