Top "Sql-job" questions

A job is a specified series of operations performed sequentially

how to schedule a job for sql query to run daily?

I need to know how to make a SQL query run daily using a SQL Server Agent job, with minimum …

sql sql-server database sql-server-2008 sql-job
How to create jobs in SQL Server Express edition

Could anyone please explain to me how to create jobs in SQL Server Express edition?

sql-server sql-server-2008-express sql-job
How can I view full SQL Job History?

In SQL Server Management Studio, when I "View History" for a SQL Job, I'm only shown the last 50 executions of …

sql-server ssms history sql-job sql-agent
SQL Server Agent Job - Exists then Drop?

How can I drop sql server agent jobs, if (and only if) it exists? This is a well functioning script …

sql sql-server sql-server-agent sql-job
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'

I'm getting the following error when trying to read a SQL Job. The SELECT permission was denied on the object …

sql-server-2005 permissions sql-server-agent sql-job
How can I Schedule a Sql job in Microsoft Azure SQL database?

I have one SQL Agent maintenance job which checks the index fragmentation within a database and rebuilds indexes if required. …

sql sql-server azure-sql-database sql-job
SQL Server Agent not running

None of the SQL Jobs on my server are running. I've looked into this and got the message: SQLServerAgent is …

sql-server-2008 sql-server-agent sql-job
SQL - How to find currently running job steps through TSQL

I am writing a query to find currently running job in SQL (I know we can view it in Job …

sql tsql sql-job
What do the Categories in SQL Server Agent Jobs mean?

This is the first time I am trying for the SQL Job Agent...I was trying to create the sample …

sql-server sql-server-2008 sql-server-2005 sql-job
Transfer SQL job to another machine

How can I transfer my SQL Agent job (maintenance plan) from my server to another server? I use SQL Server 2008 …

sql-server-2008-r2 sql-job