couldn't schedule a job on production server

Question

couldn't schedule a job on production server

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184395 More actions · Answer 1

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 · Answer 2

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: 184395 More actions · Answer 3

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