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
 SQL Server Administration (2000)
 about jobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-09 : 09:26:41
ganesh writes " we are having sqlserver 2000, we have created a job and time interval is 15 minutes. for every 15 mts a procedure will be called. after creating a job we found it is not running.

can u suugest something to do at the earliest."

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-04-09 : 09:53:13
When you open Enterprise Manager and select 'Jobs' from the Management tree, you'll see a list w/ six columns - name, category, enabled, runnable, scheduled, status. make sure enabled, runnable, and scheduled all say 'Yes'.

setBasedIsTheTruepath
<O>
Go to Top of Page
   

- Advertisement -