Run program after inserting new data set

[olivogt]

Hello, I would like to auto-run a program after inserting a new
dataset.

The new dataset is in my case a new DotNetNuke user (table: users).
The program is "barcode2image.exe" which generates a bar-code image
depending on the DnnUserID.

At the moment I run a scheduled task every hour.
However, I would like to display a customised item (with the bar-code
image) immediately after generating the new user
Hence, I was just wondering if there is a way to write a trigger to
run the barcode2image.exe immediately after user registration...

Many thanks,
Oliver

[Erland Sommarskog]

Post by olivogt
Hello, I would like to auto-run a program after inserting a new
dataset.
The new dataset is in my case a new DotNetNuke user (table: users).
The program is "barcode2image.exe" which generates a bar-code image
depending on the DnnUserID.
At the moment I run a scheduled task every hour.
However, I would like to display a customised item (with the bar-code
image) immediately after generating the new user
Hence, I was just wondering if there is a way to write a trigger to
run the barcode2image.exe immediately after user registration...

If you would run it as part of the trigger, it would during registration,
which could slow things down. But you could use Service Broker and the
activation procedure could be a CLR procedure which incorporates the
code for generating the bar code. (I assume that is a C# program.)

Or can't you initiate generation of the bar code from the client-side
of things?

[olivogt]

Hello Erland, Thank you for the reply.

From your answer I can see that there is some more programming to be
done - I was rather looking for an option to run a scheduled task from
within the SQL Management Studio. May be I leave the Windows task
schedule once per hour....

Many thanks,
Oliver

Post by Erland Sommarskog

Post by olivogt
Hello, I would like to auto-run a program after inserting a new
dataset.
The new dataset is in my case a new DotNetNuke user (table: users).
The program is "barcode2image.exe" which generates a bar-code image
depending on the DnnUserID.
At the moment I run a scheduled task every hour.
However, I would like to display a customised item (with the bar-code
image) immediately after generating the new user
Hence, I was just wondering if there is a way to write a trigger to
run the barcode2image.exe immediately after user registration...

If you would run it as part of the trigger, it would during registration,
which could slow things down. But you could use Service Broker and the
activation procedure could be a CLR procedure which incorporates the
code for generating the bar code. (I assume that is a C# program.)
Or can't you initiate generation of the bar code from the client-side
of things?
--
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[Erland Sommarskog]

Post by olivogt
From your answer I can see that there is some more programming to be
done - I was rather looking for an option to run a scheduled task from
within the SQL Management Studio. May be I leave the Windows task
schedule once per hour....

For one thing, I have no idea how your application looks like. Applications
usually do not include SSMS...