The job tag has no wiki summary.
1
vote
1answer
35 views
How to run recurring tasks on a Postgresql database without a cron-like tool?
I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent.
...
3
votes
1answer
564 views
How to succesfully run a batch file in an SQL Agent job?
I have a SQL Agent Job which generates a specific report in PDF-file and then copies the PDF to a network directory and then deletes the PDF file in the source directory.
The SQL Jobs consists of 2 ...
0
votes
1answer
58 views
sql job cancel triggers failure notification
When I cancel a sql agent job running an ssis package, I get a failure email because I set up the notifications to email when the Job Fails.
Does anyone know why this is considered a 'failure'?
3
votes
2answers
223 views
Backup Only Database Schema Everynight
I have an instance with 15 databases on SQL Server 2012. I will set up to backup system which will work every night. I want to backup only the schema because several databases are very big. I haven't ...
3
votes
1answer
238 views
Agent job will not run
I created a JOB to run a simple package that runs a query and saves the results to an Excel file. If I try to run the job In SQL Management Studio I get an error saying:
SQLServerAgent is not ...
