when start a job i get the error :
Error 22022 : SqlServerAgent error : job 0x ............ does not exists
in the job cache.
Solutions ?What happens if you try to start the job from Query Analyzer, using
msdb..sp_start_job?
Are you able to execute sp_help_job on this job?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Catalin Tudorescu" <catalint@.ager.ro> wrote in message
news:uaOAR#juDHA.3416@.tk2msftngp13.phx.gbl...
when start a job i get the error :
Error 22022 : SqlServerAgent error : job 0x ............ does not exists
in the job cache.
Solutions ?|||sp_start_job return same error.
sp_help_job work.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eqru2GkuDHA.1224@.TK2MSFTNGP09.phx.gbl...
> What happens if you try to start the job from Query Analyzer, using
> msdb..sp_start_job?
> Are you able to execute sp_help_job on this job?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Catalin Tudorescu" <catalint@.ager.ro> wrote in message
> news:uaOAR#juDHA.3416@.tk2msftngp13.phx.gbl...
> when start a job i get the error :
> Error 22022 : SqlServerAgent error : job 0x ............ does not
exists
> in the job cache.
> Solutions ?
>
>|||stop/start sqlagent might help
jobi
"Catalin Tudorescu" <catalint@.ager.ro> wrote in message
news:uaOAR#juDHA.3416@.tk2msftngp13.phx.gbl...
> when start a job i get the error :
> Error 22022 : SqlServerAgent error : job 0x ............ does not
exists
> in the job cache.
> Solutions ?
>|||Are you able to create new jobs at all?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Catalin Tudorescu" <catalint@.ager.ro> wrote in message
news:uvwABykuDHA.1876@.TK2MSFTNGP09.phx.gbl...
sp_start_job return same error.
sp_help_job work.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eqru2GkuDHA.1224@.TK2MSFTNGP09.phx.gbl...
> What happens if you try to start the job from Query Analyzer, using
> msdb..sp_start_job?
> Are you able to execute sp_help_job on this job?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Catalin Tudorescu" <catalint@.ager.ro> wrote in message
> news:uaOAR#juDHA.3416@.tk2msftngp13.phx.gbl...
> when start a job i get the error :
> Error 22022 : SqlServerAgent error : job 0x ............ does not
exists
> in the job cache.
> Solutions ?
>
>
No comments:
Post a Comment