myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

How to create SQL Job in mylittleadmin ? Options · View
harnish
Posted: Monday, June 06, 2011 10:25:26 AM
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
elian
Posted: Monday, June 06, 2011 10:39:15 AM

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.
harnish
Posted: Monday, June 06, 2011 11:08:18 AM
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
elian
Posted: Tuesday, June 07, 2011 9:49:58 AM

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
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.