|
|
Rank: Newbie
Groups: Member
Joined: 6/6/2011
Posts: 1
Points: 9
|
Hi,
I want to create one job in "sql2005admin.websecurestores.com"
But there is not any option in left panel just like sql server
management studio.Still i create a job by executing script. But i am not sure that my job is working or not.
When i try to execute below script to check my job's status.
msdb..sp_help_jobschedule @job_name='MyJob'
It gives me this error:
"The EXECUTE permission was denied on the object 'sp_help_jobschedule', database 'msdb', schema 'dbo'."
I want to perform some action on my table on schedule base.Then how can i do this ?
This is an urgent issue.So i am thankful if anybody help me
Please help me..
Thanks,
Harnish
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
myLittleAdmin does not offer any GUI to manage jobs.
About the permission error you have : it looks like you are using a shared SQL Server. The administrator of this server did not give the permissions to edit, create etc. jobs.
|
|
Rank: Newbie
Groups: Member
Joined: 6/6/2011
Posts: 1
Points: 9
|
Thanks for reply.
But i want to perform some action on my table on every 4 hours.
So i have created job to perform this task.
But as per your answer, i can not create a job. Then how can i complete this task.
Please help me..
Thanks,
Harnish
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
The only solution is that you contact your webhosting company
|
|
|
Guest |