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?
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?