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 2000 Forums
 MSDE (2000)
 How to configure jobs and agents?

Author  Topic 

Photogregor
Starting Member

1 Post

Posted - 2010-09-28 : 05:59:52
Hi,

I've got an error message on my SBS 2003:

Source: SQLServerAgent
Event ID: 208

SQL-Server Scheduled Job "epo_hip_installation" - Status: Failed
The job was invoked by Schedule 9 (epo_installation)


In serveral forums I read about "Server Manager" where you should reconfigure "Jobs" which belong to "SQL Server Agents". But my problem is that there is no Server Manager on this computer. There only is a "Microsoft SQL Server Management Studio Express" tool (it reports the underlying database as SQL Server "8.0.760"). And this tool does not offer any possibility to edit SQL Server Agents.

It's true, there once was a product installed named "epo" (from McAfee), obviously there are some ruins left after uninstallin this product. But how can I configure "SQL Server Agents" respectively their "jobs"?

Thanks for any hint and best regards,
Patrice

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-28 : 13:15:51
If you want to use a GUI for this, you'll need to get the SQL 2000 tools installed, which will include Enterprise Manager and Query Analyzer.

Otherwise, you can run sqlcmd.exe from the command line and run sp_delete_job to remove the job. See Books Online for details.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -