September 30, 2002 at 3:46 pm
I've set up a dts package to run a sql query and save the result to a text file. The package fails to run on schedule because "sql server agent is stopped. Be sure it is running during the scheduled execution of this package."
How do I make sure sql server agent is running, and that it is safe.
http://www.securiteam.com/windowsntfocus/5MP0F2K80O.html and /5LP0E2K80K.html have me worried!
Hope this is a nice simply resloved question, thanks for helping.
October 2, 2002 at 10:31 am
We have our SQL Server agents running all the time and I am sure most other servers do as well. This is a needed service for automated tasks.
I read the article you included. If this is a concern you should be able to remove the grant permissions from the public role for the SP's mentioned in the article (sp_add_job and sp_add_job_step) and any or all others. I believe you can also modify the permissions for the public role to reduce them.
Be sure to test any changes you make on a development server first since you will be modifying permissions to SP's in the msdb.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply