couldn't schedule a job on production server

• mailpraveenareddy

  Grasshopper

  Points: 16

  More actions

  November 12, 2008 at 9:59 am

  #124299

  Hi,

  I need to schedule a job which will run for every 15min and update the status. I can schedule this on my local computer but when i script the job and executed it on my hosting company production server (sql server 2000) i am getting error while executing the job,

  Server user "my user name" is not a valid user in database msdb

  I dont know what is causing this error also searched on the web for possible solution but couldn't get any , any help woulb be highly appreciated.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 12, 2008 at 10:32 am

  #897649

  You do not have rights on the production server to create jobs. In 2000 I believe you need to be in the sysadmin or processadmin group to create jobs .

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• mailpraveenareddy

  Grasshopper

  Points: 16

  More actions

  November 12, 2008 at 10:35 am

  #897651

  Thanks for the reply, So there is no option that we can run jobs on prodution server??

  What other options that i have, to update the status for every 15min.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 12, 2008 at 11:03 am

  #897668

  Does your provider agreement include job scheduling? If not you may not have the option of jobs. You may have to write your own scheduler that connects and runs the T-SQL.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question