SQl server 2000 scheduling jobs

[S1002]

Can a user with fixed database role given sql authentication to connect to the sql server schedule jobs
by any means.

Thank you

 

[mrdenny]

Yes, all users can schedule jobs by default. Those jobs will then run under the users login at the scheduled time.

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

 

[S1002]

Thank you Denny

 

[S1002]

One more question,
Does that mean the user should 'sa' previlages?

 

[mrdenny]

S,
I'm not sure what you are asking.

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

 

[S1002]

Iam sorry to reply you back after a long time.

There was a little confusion but it is cleared.

Thank you