Post reply

Sql Server Agent

  • March 5, 2011 at 9:19 am

    #388978

    I have a website using Sql Server 2008. The site is hosted at shared server.

    I do not have access to Sql Server through Enterprise Manager and I have to use Query Analyzer to manage db tables etc.

    So now using Query Analyzer, how can I:

    1- Check if I have access to sql server agent or start sql server agent.

    2- As I can access sql server through Query Analyzer only (and not by Enterprise Manager), so just by using QA is it possible to create a job that send email alters to db users?

    Thanks!

    Zeeshan

  • March 5, 2011 at 9:35 am

    #1294996

    zeeshandar (3/5/2011)

    I have a website using Sql Server 2008. The site is hosted at shared server.

    I do not have access to Sql Server through Enterprise Manager and I have to use Query Analyzer to manage db tables etc.

    So now using Query Analyzer, how can I:

    1- Check if I have access to sql server agent or start sql server agent.

    2- As I can access sql server through Query Analyzer only (and not by Enterprise Manager), so just by using QA is it possible to create a job that send email alters to db users?

    Thanks!

    Zeeshan

    The Agent requires admin permissions so you may not have access to it without help from the hosting company, however you can write code to send automated emails from your website without access to the Agent.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

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