I need to stop a Job from ever starting if certain conditions are not met. So Step 1, would call a procedure (or DTS?) that would return a boolean (T/F) to continue the job. I have the SP created, that simply does a Select against a table. So... what is my next step? I've never returned values from an SP, although I have used the DTSRun flag before to abort a DTS Package? I was leaning to DTS since I know how that can work... Can I simply call the SP directly though? tia..
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...