User security to monitor jobs

  • How do I setup users to be able to monitor DTS jobs, but not to allow than to start or stop them?

  • For example you may use an ASP page that queries MSDB connected as a read-only user for MSDB. The script should query sysjobs and sysjobhistory and return a job name, step name and run_status. Is that what you mean by monitoring, to be able to see if the job is completed successfully?

    Yelena

    Regards,Yelena Varsha

  • The only way to revoke the permissions to start or stop the DTS packages ,Save the Package with  Password.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply