Where is the SQL Server Database Trigger Wizard or Dialog Box?

Databases
1

This question is about SQL Server

In the past, I have created a stored procedure that was run on a timely basis by (if I remember correctly) a database trigger. As I recall, there was a wizard (dialog box with “NEXT” buttons) that I used to set things up to have the stored procedure run automatically. That was some time ago. Now when I search for database trigger information online, I find only information about – creating triggers for when a table is updated or modified. Maybe I am using the wrong terminology and what I am looking for is not a “trigger” at all.

2

Are you talking about SQL Server agent which can be used to schedule the run of stored procedures? Check out this article and see if this is what you are talking about…

https://atlasprecon.com/create-sql-job-run-stored-procedure/

1 Like
3

I think so. I will have a look.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.