The following desk summarizes SQLAgentOperatorRolepermissions on SQL Server Agent items. They cannot delete job history for any other tasks. Members of SQLAgentReaderRolemust clearly be granted the EXECUTE permission on sppurgejobhistoryto remove job history on careers that they possess. Listing of proxies just accessible in the Job Step Propertiesdialog container of Management Studio. ![]() MotionĬan obtain listing of available operators for make use of in spnotifyoperatorand the Job Attributesdialog container of Administration Facility. The adhering to desk summarizes SQLAgentReaderRolepermissions on SQL Machine Agent objects. ![]() They cannot remove job background for any various other job opportunities. People of SQLAgentUserRolemust clearly be given the EXECUTE authorization on sppurgejobhistoryto delete job background on work opportunities that they own personal. ActionĬan get checklist of obtainable employees for make use of in spnotifyoperatorand the Work Attributesdiscussion box of Management Facility.Ĭhecklist of proxies just accessible in the Work Step Qualitiesdiscussion container of Management Recording studio. The adhering to table summarizes SQLAgentUserRolepermissions on SQL Server Agent objects.
0 Comments
Leave a Reply. |