Agent job with powershell

Question

Agent job with powershell

jdbrown239

SSCarpal Tunnel

Points: 4393
More actions
June 19, 2014 at 5:32 pm

#290204

Hi
I am trying to create an agent job that looks for a file to exist and file if the file is not fount. I am using a try\catch block but the job will not fail. Any ideas?
try {
Get-Item -Path E:\Migration Files\myfile.txt -ErrorAction Stop
} catch {
# File Does Not Exist
}

Viewing 3 posts - 1 through 2 (of 2 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

i've used Test-Path to see if files or folders exist, and make a decision from there to do my logic; create files, process files, copy them or whatever.

#the detail file of this database:

$filename = $dir + $NiceServerName + '\'

if (!(Test-Path -path $filename))

{

New-Item $filename -type directory

}

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

jdbrown239 SSCarpal Tunnel Points: 4393 More actions · Answer 2

Thanks

I didn't want to add any other logic to the script just have the job step fail if the file is present. Someone suggested just using the Get-item by itself and it did the trick.

Get-Item -Path E:\Migration Files\myfile.txt -ErrorAction Stop