[CC] 2009 Replacing NAS with SQL Jobs and Webservice

elTorito

Hi,

i came across from here , but i can't leave a comment , my mibuso login don't work on the blog ...

i have some questions about that, perhaps anybody can help me.

i have downloaded the example, and register the downloaded dll on a sql server 2008 , then i create a sql job like in the example :



But how must be the Storage Procedure?

For test purposes i create this one:

ALTER PROCEDURE [dbo].[NavJobScheduler] (
@Code varchar(40),
@Name varchar(50)
)
AS INSERT INTO dbo.[MyCompany12_05$Test_Table] (Code, Name) VALUES(@Code, @Name)

Running the SQL Job, error apperas that are too arguments passing to the SP (seems logic)...

but what i'm must put in , in the SP ? so i can this example work? (For view what is this example making, because i don't understand very well what is workflow)

Thanks