Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Job Error

Author  Topic 

jmohanraj
Starting Member

2 Posts

Posted - 2009-09-18 : 00:47:58
Executed as user: XXX\XXX_Service. Update interval has not been set. [SQLSTATE 42000] (Error 50000). The step failed.

receiving an error on sql server. Any help.

Thanks.

ajitgadge
Starting Member

12 Posts

Posted - 2009-09-18 : 05:50:38
It's look like corresponding user do not have permission to execute the task. Can you please tell where do you get this error ?
Go to Top of Page

jmohanraj
Starting Member

2 Posts

Posted - 2009-09-18 : 07:23:15
In Job -> View History -> Log Viewer.

Thanks
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2009-09-18 : 12:30:27
login XXX/XXX_Service do not have appropriate privileges.
Go to Top of Page
   

- Advertisement -