The current version of MAS 500's SQLSchedulerUtils.DLL does a fine job setting up a basic SQL Job on SQL Server. However, it lacks the functionality to set the Run As User property that can be seen on the Advanced tab when editing a SQL Job step.

The DLL makes a call to SQL's sp_add_jobstep and sp_update_jobstep to create and update the jobs steps created by the DLL. One of the optional parameters of these store procedures is called @database_user_name. Setting this value sets the Run As User propety on the Job Step screen.

Having the ability to set this value through the DLL will allow in a greater degree of flexibility when creating new SQL Schedules/Jobs when using it.

by: Louis D. | over a year ago | 6 - General Enhancements