When creating recurring schedules with intra-day parts, StartTime and EndTime define the execution window. Despite the confusing names, StartTime and EndTime have nothing to do with StartDate and EndDate for a schedule. StartTime and EndTime define...

Auditing can be used to track and log events that occur on system. You can read more about auditing here . SQL Agent jobs are added / removed using stored procedure interface sp_add_job and sp_delete_job. Customers have asked us how we could track user...

To prevent anyone from sending arbitrary emails, Database Mail is guarded by the database role DatabaseMailUserRole. Users who are not the member of DatabaseMailUserRole cannot send emails except sysadmin who has all privileges. For example, an unauthorized...