Question regarding security required for SQL jobs in 2005

[kodaksmile]

Quick question,

We have a third party scheduler that we would like to use to schedule all of our jobs (not just sql). In SQL 2005 what permissions are required to be able to execute SQL jobs that were created by a different user?

Thanks,

 

[mrdenny]

SQL Agent Operator role in the msdb database.

If you are using a third party scheduler you probably won't be using the SQL Jobs at all and putting all the code for the jobs within the 3rd party scheduler.

Which scheduler are you using?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kodaksmile]

I was wondering if the operator role would do it or if that would only work for jobs owned by the account being used. Actually the application we are running creates the jobs so it would be easier to just call the job via the third party software (which is Tidal) than to recreate all the jobs.

 

[mrdenny]

The operator role should do the trick for you.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog