smthembu (10/13/2009)
HiWhen i execute spaceanalysis.job it fails with the below or is it me
Msg 206, Level 16, State 2, Procedure sp_add_jobstep, Line 0
Operand type clash: int is incompatible with uniqueidentifier
Updated job script, I was missing the server instance and repository parameters in the job. The two job steps should look like this:
& C:\bin\Write-VolToDb.ps1 ' Z002\SQL2K8' spacedm
& C:\bin\Write-DbSpaceToDb.ps1 ' Z002\SQL2K8' spacedm