locked
New file notification RRS feed

  • Question

  • 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.

     

    Thursday, December 28, 2006 7:28 PM

Answers

  • 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

    Monday, January 15, 2007 12:16 PM

All replies

  • You can make use of the inbuilt "Event Provider" that monitors a specific folder.  For more information, read about "Event Providers"
    Saturday, January 13, 2007 4:03 PM
  • 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

    Monday, January 15, 2007 12:16 PM
  • 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

    Tuesday, January 16, 2007 6:25 PM
  • 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

    Tuesday, January 16, 2007 6:30 PM
  • That's great, AE.

    Is there anything that you could share with the group?

    Thanks!

    Joe

    Thursday, January 18, 2007 1:09 PM
  • No Joe, just the link I provided for a good sample application in my previous message.

    Ahmet

    Monday, January 22, 2007 9:16 PM