New file notification

Hi All,

I am vey new to NS and here is what I am trying to achive:

User creates/copies over a file on the network. When this happens, I want to start an existing Job (SQL stored procedure) in SQL Server Agent.

Any lead (existing sample applications etc.) for me to start is apprecitated.

Thank you.

You can make use of the inbuilt "Event Provider" that monitors a specific folder. For more information, read about "Event Providers"|||Is this for some kind of ETL process? I'm not sure that SSNS is the best tool available for you here.

If you believe that it is the best tools, consider these options:

SSNS does come with a FileSystemWatcher event provider, but it looks for a valid XML document in the watched folder. If you're files are something besides a valid XML document, you can create a custom event provider using any .NET Framework language.

SSNS is designed to deliver notifications rather than start processes. So, you would need to create a custom delivery channel to start your SQL Server Agent process.

HTH...

Joe|||

Thank you Ragas. I looked at some online examples and worked it out. This article was quite helpfull:

http://www.devx.com/dbzone/Article/28522

|||

Thank you Joe. Yes, it is an ETL process and SSNS works pretty well. I downloaded this example and figured it out eventually: http://www.devx.com/dbzone/Article/28522

I added a trigger to start my SQL Agent job on one of the Notification Application tables when a new notification record is created.

AE

|||That's great, AE.

Is there anything that you could share with the group?

Thanks!

Joe|||

No Joe, just the link I provided for a good sample application in my previous message.

Ahmet