Solved

sql 2012 - run a job

Posted on 2014-07-21
1
248 Views
Last Modified: 2014-08-05
Hello,
I need to run a job in Sql server 2012. The service provider has added Sql Server Agent but I cannot see it in my Sql server management studio express 2012. What can I do to access it?
Greetings
0
Comment
Question by:johnson1
1 Comment
 
LVL 18

Accepted Solution

by:
Peter Hutchison earned 500 total points
ID: 40208734
Its not possible to run sql jobs via the Studio Management Studio. Instead you can create jobs using a bit of Notepad, the SqlCmd.exe and the Task Scheduler.
Open notepad and save the sql statements in a .sql file on the server somewhere e.g. d:\MSSQL\Jobs.
Create a new Scheduled Task and run the sql file as a given user e.g.

Sqlcmd.exe -I script.sql -U username -P password

There are some third party Agents but you have to check the documentation that came with them.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now