xp_cmdshell question 1

[equus2]

When I run this from Mgmt Studio:

EXEC master..xp_cmdshell 'DEL C:\mypath\*.master.*'
GO

It gives this message:
Could Not Find C:\mypath\*.master.*

Runs fine from my job...

What is the problem here?

Thanks

 

[equus2]

Actually nevermind --- file wasn't there - duh

 

[gmmastros]

You can use xp_fileexist to determine if a file exists.

Declare @FileExists Int
Exec master..xp_fileexist 'C:\YourFileName.ext', @FileExists Out

Select @FileExists

@FileExists = 1 if the file exists. Otherwise it is 0.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom