Re: Jobs not running manually or scheduled

Is your SQL Server Agent running? If not, you should run it first for
the sheduled job.
I think that why the Next Run Date column says "(Date and Time are not
unavailable)".

Thanks,

Atkins wrote:
I'm assisting someone who started having trouble with most of their
scheduled SQL jobs not running after they moved their server to a new
location/plant. As a side note, my understanding is the servers belong
to their own domain so this move should not have affected things too
much.

Furthermore, the Jobs do not seem to run when you right click and
choose start job. There is no indication of success or failure The
Next Run Date column says "(Date and Time are not unavailable)" and
Last Run Status column says "Unknown". "View Job History..." says
"There is no history information for this job".

I have created a new Test job with one step and one line containing a
print statement. On the Step's Advanced tab I set it to output to a
file. However, again there is no sign that the step was executed.
Because the file was not created and the Job status and history still
displays the same messages. I should also mention that this was using
the same owner as the other jobs that are working and that the owners
I've tried are sysadmins. One is a windows account and the other is a
SQL Account. The jobs that are working are using the SQL Account.

The Server is SQL Server 2000 RTM (no Service packs installed) on
Windows 2000 Standard w/ SP3

Thanks for any help!

.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Business Data Catalog
    ... das Problem habe ich immer sobald der SQL Server under MOSS 2007 ... Einen SQL Account verwenden: ... Am SharePoint Server selbst funktioniert der zugriff auf die Daten! ... Anschliessend die Berechtigung auf den BDC eintrag erteilt, ...
    (microsoft.public.de.german.sharepointportalserver)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)