I have an ETL package that goes out to an oracle database, checks for new data, and if it finds new data, it imports the data into our inventory management system.
I was thinking about creating a sql trigger that would fire off (somehow) a workflow process to send and email to the receiveing department to work on the new items that were just imported into the database.
Thanks in advance
One way of doing this is to create a Windows scheduler job or a console app or a batch script and call one of them within your SQL Server Agent Job "Operating System Command (CmdExec)"
Refer to this sample on how to set data fields and start an instance.
http://help.k2.com/en/k2blackpointdevref.aspx?page=Start_Instance_and_Get_Data_Fields.html
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.