Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql server agent-doesn't work

Status
Not open for further replies.

mici

Programmer
Jun 2, 2003
36
0
0
IL
I have created a job in the sql server agent by
Management->SQL Server Agent->Jobs->New Job->Steps->New->there i put execute xxx_procedure.
Then in the scheduler I configured the time .

i right clicked the sql agent and choose 'start'.

The job didn't work, i saw under jobs " last run status"--> unknown.
What is the problem?
 
Are you absolutely sure the SQL Server Agent is running?

The last run status will change to unknown if the service is stopped.

Have you rebooted since you started the service? Make sure the service is set to start when OS starts

Andy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top