Schedule a PS Script using SQLServer Agent

Question

Post reply

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: 737892 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 737892

September 4, 2009 at 12:33 pm

#1049571

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

Jack Corbett SSC Guru Points: 184394 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: 184394 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: 737892 More actions · Answer 5

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

Schedule a PS Script using SQLServer Agent

Cookies on SQLServerCentral